macro to compile data over time

wallywalls3rd

New Member
Joined
Mar 22, 2016
Messages
2
I am collecting data for a project at work. so far I have a workbook for each person to collect data and a page for each day of the month in those workbooks. at the end of the month I am copy pasting it into a master copy for that month. and again for a master copy for the quarter/year. I will be using this information to track trends using pivot charts and tables. is there a macro that I can use that would pull all of the data to the next "master" sheet? kind of like a pyramid. so the employees would pull to the month, the month would pull to the quarter, and the quarter would pull to the year? I am newer to excel and have done all of this on my own. but I am not macro savvy in the slightest. but I have some coworkers that can help me implement it if I were to have the macro coding itself.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,123,270
Messages
5,600,638
Members
414,398
Latest member
dhune

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top