Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Summary Worksheet
Is there a way to populate a summary worksheet with the details of 4 other
worksheets, all of which have the same number of columns (A:J with the labels on row 5) yet have different numbers of rows (each sheet will have a different number of rows with the data beginning on row 6 in each sheet). Is it possible to do without running a macro so that the summary sheet will look to be automatically populated with as many rows as there are on sheet number 1, then look to be populated with as many rows as there are on sheet number 2, etc. Any help would be much appreciated. Thanks Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update cell in other worksheet based... | Excel Worksheet Functions | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
Summarize multiple worksheet detail on summary sheet | Excel Discussion (Misc queries) | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions |