| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy subtotaled data
I have a spreadsheet that has been subtotaled. The formula in the subtotal
cell is “=subtotal(3,j2:j61)” . Is there a way ,Using this information from the subtotal formula, which is the number of rows with each client's info. I would like to run a macro to copy the data from cells a2:q61 to a new worksheet named with contents of cell “I”. This process needs to repeat down thru aprox 6500 rows that have all been subtotaled down to 1500 separate lines . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy subtotaled data without underlying details in Excel | Excel Worksheet Functions | |||
| Using Subtotaled Data | Excel Worksheet Functions | |||
| subtotaled spreadsheet? | Charts and Charting in Excel | |||
| individual tabs for subtotaled data | Excel Discussion (Misc queries) | |||
| How do I copy subtotaled data without the underlying details? | Excel Worksheet Functions | |||
Threaded Mode
