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.

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.

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.