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