Consolidate different worksheets into one worksheet

H

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.
 
K

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


Ron de Bruin said:
 
R

Ron de Bruin

Hi Khoshravan

See my answer in your other thread

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



Khoshravan said:
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.
 
K

Khoshravan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top