I have roughly 50 workbooks formated the same way (identicle); basically statistics kept on a group of individuals per day. I need to have this added up into a summary of the month.
We originally were using a seperate format for the summary workbook because it did not need to be as detailed as the daily information. In the end we had tons (thousands) of paste specials automatically filling in almost all fields.
There is one column that paste special does not work because one cell (colmn actually) needs to be a total of the same cell from all those 50 workbooks. Consolidate sounded like the answer, but it appears to be a 1-time thing; when we consilidate on day 3, at day 5 re-consolidating is inaccurate, and adds cells. We would like to be able to access the monthly totals at anytime for an up-to-date summary.
Please, if anyone can even point me in the right direction I would greatly appreciate it. To summarize my goal, it's to have "paste special" functionality from multiple cells/workbooks into one cell that adds them up, and of course have this be automatic.
If it would be simpler to litteraly use the same exact format for the summary workbook I am fine with that, it'll just be more detailed than we need. I just need it available day 1-31, and be updated upon opening the Excel.
Thank you VERY much.
Bookmarks