I have a spreadsheet for which I need to summarise "revenue data". This is on
row 21 on all sheets. There is also a "summary " sheet already in the
spreadsheet which I want to ignore but I do not wish to delete it..
I need my summary data to go on a new sheet called "Consol Rev". The consol
will take row 21 data from all sheets and copy to the next available blank
row. The number of sheets varies depends on which parameters are picked by
the user when running the report.

After I have got summary revenue data I need another macro to also summarise
"Gross Profit" data . This is on line 38 on all sheets. In my new "consol
GP" sheet I would need to take data on line 38 from all sheets except for
"Summary" and "Consol Rev"

see excel help - Consolidate data in multiple worksheets

"manfareed" wrote:

> I have a spreadsheet for which I need to summarise "revenue data". This is on
> row 21 on all sheets. There is also a "summary " sheet already in the
> spreadsheet which I want to ignore but I do not wish to delete it..
> I need my summary data to go on a new sheet called "Consol Rev". The consol
> will take row 21 data from all sheets and copy to the next available blank
> row. The number of sheets varies depends on which parameters are picked by
> the user when running the report.
>
> After I have got summary revenue data I need another macro to also summarise
> "Gross Profit" data . This is on line 38 on all sheets. In my new "consol
> GP" sheet I would need to take data on line 38 from all sheets except for
> "Summary" and "Consol Rev"

hi..

thanks for the hint but i was looking for a macro.

thanks

"DomThePom" wrote:

> see excel help - Consolidate data in multiple worksheets
>
> "manfareed" wrote:
>
> > I have a spreadsheet for which I need to summarise "revenue data". This is on
> > row 21 on all sheets. There is also a "summary " sheet already in the
> > spreadsheet which I want to ignore but I do not wish to delete it..
> > I need my summary data to go on a new sheet called "Consol Rev". The consol
> > will take row 21 data from all sheets and copy to the next available blank
> > row. The number of sheets varies depends on which parameters are picked by
> > the user when running the report.
> >
> > After I have got summary revenue data I need another macro to also summarise
> > "Gross Profit" data . This is on line 38 on all sheets. In my new "consol
> > GP" sheet I would need to take data on line 38 from all sheets except for
> > "Summary" and "Consol Rev"

>> thanks for the hint but i was looking for a macro.

See
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"manfareed" <(E-Mail Removed)> wrote in message news:719EE343-F4CA-4627-9C86-(E-Mail Removed)...
> hi..
>
> thanks for the hint but i was looking for a macro.
>
> thanks
>
> "DomThePom" wrote:
>
>> see excel help - Consolidate data in multiple worksheets
>>
>> "manfareed" wrote:
>>
>> > I have a spreadsheet for which I need to summarise "revenue data". This is on
>> > row 21 on all sheets. There is also a "summary " sheet already in the
>> > spreadsheet which I want to ignore but I do not wish to delete it..
>> > I need my summary data to go on a new sheet called "Consol Rev". The consol
>> > will take row 21 data from all sheets and copy to the next available blank
>> > row. The number of sheets varies depends on which parameters are picked by
>> > the user when running the report.
>> >
>> > After I have got summary revenue data I need another macro to also summarise
>> > "Gross Profit" data . This is on line 38 on all sheets. In my new "consol
>> > GP" sheet I would need to take data on line 38 from all sheets except for
>> > "Summary" and "Consol Rev"