I have been searching all morning for a topic similar to this but none are quite right for my situation.
I need to take only selected sheets (daily sheets names Monday through Friday) in a workbook and compile them into a summary sheet for the week named "Summary". My issue is that the daily sheets will have lines added by users that could exceed 50+ and these changes need to be automatically updated into the summary without having to manually running the macro again.
I also need a macro to take the totals line in each day to copy into a separate sheet (Totals) with only the daily totals to be displayed. This also needs to automatically update when anything is added.
Attached is a working copy of the file.
Edit - cross posted to http://www.mrexcel.com/forum/excel-q...ml#post3706782
Bookmarks