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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate different worksheets into one worksheet
Hi Hennie
Start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Hennie" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate different worksheets into one worksheet
Dear Ron
I referenced your reply to following question. looks very good solution and try to use your method. how ever little hard for me digest. My problem: I was able to copy the Macro but Where/how should I insert Function? (I want to use Function Lastcol) will be happy to get your input. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: Hi Hennie Start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Hennie" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate different worksheets into one worksheet
Hi Khoshravan
See my answer in your other thread -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... Dear Ron I referenced your reply to following question. looks very good solution and try to use your method. how ever little hard for me digest. My problem: I was able to copy the Macro but Where/how should I insert Function? (I want to use Function Lastcol) will be happy to get your input. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: Hi Hennie Start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Hennie" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate different worksheets into one worksheet
I was able to perform "consolidate" command.
Now what is the general name of those + and - signappearing on left of raw numbers? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: Hi Khoshravan See my answer in your other thread -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... Dear Ron I referenced your reply to following question. looks very good solution and try to use your method. how ever little hard for me digest. My problem: I was able to copy the Macro but Where/how should I insert Function? (I want to use Function Lastcol) will be happy to get your input. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: Hi Hennie Start here http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Hennie" wrote in message ... 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 |
Reply |
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 |