| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract data from multple worksheets to a summary worksheet
I have more than 100 worksheets in one workbook, I would like to make a
summary sheet within the same workbook that includes three columns. The first column is the name of each sheet; the second includes the date duration "from to", and the third column is the total in each worksheet. each sheet has the total in cell F54. I also would like for the summary sheet to be automatically update whenever a new sheet is added. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
extract data from multple worksheets to a summary worksheet
Hi,
See Ron webpage http://www.rondebruin.nl/copy2.htm if this help please click yes, thanks "TFA" wrote: I have more than 100 worksheets in one workbook, I would like to make a summary sheet within the same workbook that includes three columns. The first column is the name of each sheet; the second includes the date duration "from to", and the third column is the total in each worksheet. each sheet has the total in cell F54. I also would like for the summary sheet to be automatically update whenever a new sheet is added. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine 6 worksheets into 1 worksheet - Summary | Excel Discussion (Misc queries) | |||
| Feed Data from Multiple worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
| Extract data from list for Summary worksheet. | Excel Discussion (Misc queries) | |||
| Sorting data in a workbook across multple worksheets | Excel Worksheet Functions | |||
| Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
