| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Should i delete heading/subtotal rows when consolidating?
I am ready to try RDB's macro for consolidating several worksheets into one
using Excel 2003. 1. In preparing the worksheets to be used for consolidating, do i need to delete rows that are not "data" rows? I would still need them in the final worksheet but more for formatting the report. 2. If answer to 1 is yes, is there any way to automate the report formats in the consolidated/merged worksheet? Thanks greatly! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare and consolidating duplicated rows | Excel Discussion (Misc queries) | |||
| subtotal copy-paste and delete hidden rows | Excel Discussion (Misc queries) | |||
| Macro-delete & move heading | Excel Discussion (Misc queries) | |||
| Consolidating Rows | Excel Discussion (Misc queries) | |||
| delete column heading for print | Excel Worksheet Functions | |||
Hybrid Mode
