Consolidate different worksheets into one worksheet

[Hennie]

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.

 

[Ron de Bruin]

Hi Hennie

Start here
http://www.rondebruin.nl/copy2.htm

 

[Khoshravan]

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

Hi Hennie

Start here
http://www.rondebruin.nl/copy2.htm

 

[Ron de Bruin]

Hi Khoshravan

See my answer in your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl

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.

 

[Khoshravan]

I was able to perform "consolidate" command.
Now what is the general name of those + and - signappearing on left of raw
numbers?