MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Consolidate worksheets


Posted by John Fletcher on November 19, 2001 12:34 PM

Excel 97- I have six worksheets by month (cols.)and days (rows). each cell contains a dollar amt. that I want to sum by day and month plus total for the year and month onto a separate sheet called "Totals". Additionally, if I should insert or change data on one of the six worksheets I want it to be automatically reflected on the Totals sheet. I've used the consolidate data command but it only works after all the data on the individual sheets is completed. Not dynamically or automatically.


Posted by Mark W. on November 19, 2001 12:40 PM

Create 6 additional worksheets...

...with day and month values and Consolidate
by category (creating links for all 12
worksheets).