View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David
 
Posts: n/a
Default 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.