software

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.

Why not just use Data/Subtotals menu?
--
Davidquot;karinmpfaquot; wrote:

gt; My worksheet is sorted by customer first, then product with different package
gt; configuations. Each customer can have 1 product or many products. I want to
gt; sort through each customer by name and when I get to the last row, insert a
gt; space. Then I want to jump over several columns and enter a subtotal for
gt; that customer. I will have several columns with a sub total in each for a
gt; customer.

Will that automatically insert a row in between each customer?

quot;Davidquot; wrote:

gt; Why not just use Data/Subtotals menu?
gt; --
gt; David
gt;
gt;
gt; quot;karinmpfaquot; wrote:
gt;
gt; gt; My worksheet is sorted by customer first, then product with different package
gt; gt; configuations. Each customer can have 1 product or many products. I want to
gt; gt; sort through each customer by name and when I get to the last row, insert a
gt; gt; space. Then I want to jump over several columns and enter a subtotal for
gt; gt; that customer. I will have several columns with a sub total in each for a
gt; gt; customer.