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


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



"Hennie" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" wrote:

> Hi Hennie
>
> Start here
> http://www.rondebruin.nl/copy2.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Hennie" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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
> >
>
>
>

[Ron de Bruin]

Hi Khoshravan

See my answer in your other thread

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



"Khoshravan" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >
>> > 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
>> >
>>
>>
>>

[Khoshravan]

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" <[email protected]> wrote in message news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >
> >> > 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
> >> >
> >>
> >>
> >>
>
>
>