MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel summary sheet

Posted by stephen on January 31, 2002 1:11 AM

i have a workbook with say seven sheets. Each sheet contains data for seven different companies. All sheets are in the exact same format. Assuming on a monthly basis that some sheets have say 10 lines of data and others might have 15 etc how can i do a summary sheet that puts all these lines of data onto the one summary sheet, remembering that the amount of lines contained on each individual sheet will change each month? I want to be able to do this without physically copying and pasting each month.

Posted by Remi on January 31, 2002 1:24 AM

My approach would be:
Record a macro which performs the actions you want. Then edit it to fine tune to your liking.