software

I have a spreadsheet with multiple customers who have multiple invoices.
Each invoices has several lines. I'm able to subtotal the invoices.
What I would like to do is show only the subtotal line but I would still
like to see the customer name. Is there any quick way to get the customer
name displayed on the subtotal line? Right now all the subtotal line
displays in the invoice number.

gls858

Hi

Try using a Pivot Table. You can then have a very quick analysis by
Cutomer, with totals for each Invoice.
For help on setting up and arranging Pivot Tables, take a look at Debra
Dalgleish's site, and scroll down to the Pivot section
www.contextures.com/tiptech.html

--
Regards

Roger Govier
gls858 wrote:
gt; I have a spreadsheet with multiple customers who have multiple
gt; invoices. Each invoices has several lines. I'm able to subtotal the
gt; invoices. What I would like to do is show only the subtotal line but I
gt; would
gt; still like to see the customer name. Is there any quick way to get
gt; the customer name displayed on the subtotal line? Right now all the
gt; subtotal line displays in the invoice number.
gt;
gt; gls858
Roger Govier wrote:
gt; Hi
gt;
gt; Try using a Pivot Table. You can then have a very quick analysis by
gt; Cutomer, with totals for each Invoice.
gt; For help on setting up and arranging Pivot Tables, take a look at Debra
gt; Dalgleish's site, and scroll down to the Pivot section
gt; www.contextures.com/tiptech.html
gt;
Thanks Roger. That works. I was trying to keep it real simple.
The user I'm preparing the data for knows even less than me :-)

gls858