Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate different worksheets into one worksheet
I'm using a workbook containing a worksheet for each month of the year. I want to consolidate all the data from the different worksheets into one worksheet to enable data manipulation by means of a pivot table. Updates in the individual worksheets must be automatically updated in the consolidated worksheet. -- Hennie ------------------------------------------------------------------------ Hennie's Profile: http://www.excelforum.com/member.php...nfo&userid=399 View this thread: http://www.excelforum.com/showthread...hreadid=564063 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separate worksheet into multiple worksheets by grouping | Excel Worksheet Functions | |||
'Consolidate' data from multiple worksheets | Excel Discussion (Misc queries) | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Rollup worksheets into a master worksheet - automatically? | Excel Discussion (Misc queries) | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions |