Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying Totals of separate worksheets to a single Summary Worksheet
I wonder if anyone can please help me.
I have a several workbooks containing 50 to 80 worksheets. Each workbook has a summary worksheet of the numerical totals of each worksheets. Each worksheet is named with a persons name e.g. SmithC, BlackR, HoffmanD. I'm having to at the moment to copy the totals of each worksheet to the summary worksheet, one by one. As you can imagine this takes time. Is there a quicker way to do this? Thanks, Gerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
copying cells from other worksheets | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
copying worksheets | Excel Discussion (Misc queries) |