| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a Macro to sort data and insert blank rows & subto
My worksheet is sorted by customer first, then product with different package
configuations. Each customer can have 1 product or many products. I want to sort through each customer by name and when I get to the last row, insert a space. Then I want to jump over several columns and enter a subtotal for that customer. I will have several columns with a sub total in each for a customer. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a Macro to sort data and insert blank rows & subto
Why not just use Data/Subtotals menu?
-- David "karinmpfa" wrote: My worksheet is sorted by customer first, then product with different package configuations. Each customer can have 1 product or many products. I want to sort through each customer by name and when I get to the last row, insert a space. Then I want to jump over several columns and enter a subtotal for that customer. I will have several columns with a sub total in each for a customer. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a Macro to sort data and insert blank rows & s
Will that automatically insert a row in between each customer?
"David" wrote: Why not just use Data/Subtotals menu? -- David "karinmpfa" wrote: My worksheet is sorted by customer first, then product with different package configuations. Each customer can have 1 product or many products. I want to sort through each customer by name and when I get to the last row, insert a space. Then I want to jump over several columns and enter a subtotal for that customer. I will have several columns with a sub total in each for a customer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert rows after each row of data (800 rows)? | Excel Discussion (Misc queries) | |||
| Insert blank rows repeatedly between every data row in Excel | Excel Discussion (Misc queries) | |||
| insert a blank row after data changes in a column | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Inserting Blank Rows Macro? | Excel Worksheet Functions | |||
Hybrid Mode
