• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying Daily data into a cumulative file adding a date column?

M

Maris Sofra

New Member
Hi, Just wondering what the best approach to this is...because I am definitely doing it the hard way!
I receive a daily report, with 4 pages of detail, i.e. a daily snapshot of all this data, by manufacturing site.
I would like to accumulate all the daily detail (one page per worksheet) into a NEW spreadsheet of cumulative data. The daily report only has the report date in the title.
So, what I have been doing is:
1. Opening the daily report in excel, and
2. Opening my NEW cumulative report in excel.
3. Going back to daily report and copying the detail from one tab (worksheet) into the corresponding worksheet in the NEW spreadsheet (where I have been pasting the data from previous daily reports).
4. Next, I add a "Rpt Date" to the leftmost column that I have already added to NEW report.
Since I am working with two files, the Daily and the All_Dates (NEW), I am guessing there is not a macro that I could use????? Or can I jump from one report to the other with a macro???? Would love to hear any recommendations. As we just started this, I just had to do it initially to 14 daily reports!!! Now I am just getting just one/day. It's still a pain and room for error.
 
Regarding the above query (which I should have proofed before hitting enter (Jeez!)), The date is added to each new row in the new worksheet. And I repeat this process for all four pages of the report that I get daily.
 
I'd recommend uploading sample workbooks (one each for source and your cumulative workbook), with enough data to demonstrate your need.

This can certainly be done via VBA/Macro.
 
Hi !
Maris Sofra said:
I am guessing there is not a macro that I could use?????
Click to expand...
Yes, everywhere on web and see also tutorials !

But you can start yourself your own code just activating Macro recorder
and operate manually : you will get a base of code !
Post here this generated code for an optimization if you need
and of course with attachments …

The better explanation, the better answer !
​
 
You must log in or register to reply here.
Back
Top