| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy row 21 from all sheets to a new sheet except " summary"
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
| Sheets("Sheet").Copy problem | Excel Programming | |||
| Modifying Ron De Bruin's "Create summary sheet from different workbooks" | Excel Programming | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Threaded Mode
