Copy row 21 from all sheets to a new sheet except " summary"

M

manfareed

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"
 

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