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