software

InI am trying to creating a summary of invoices that I have in a worksheet
quot;IX INvoice Dataquot; this is what my sheet looks like

Column A B C D E F
Date Invoice # Description Qty Rate Total

I have multiple invoices in the worksheet and I would like to sort this data
by the description in order to compare the rates. I will be entering more
invoices in the future and would like to avoid having to keep manullay
resorting and reformatting this data that I have been summarizing on sheet 2
quot;Inovice Summaryquot;. On the summary sheet the only data I need to see is the
Description, Qty, Rate and Total.
Also If possible I would like a way to subtotal each sorted decription
groups qty. Any ideas?First, I'd try to keep all my data in one location.

Maybe you could apply data|filter|autofilter to see the rows you want.

And you could sort the data and use data|subtotals to see subtotals.

And maybe you could just hide the columns (or data|group) to hide/show the
columns you want.

Rob #4 wrote:
gt;
gt; InI am trying to creating a summary of invoices that I have in a worksheet
gt; quot;IX INvoice Dataquot; this is what my sheet looks like
gt;
gt; Column A B C D E F
gt; Date Invoice # Description Qty Rate Total
gt;
gt; I have multiple invoices in the worksheet and I would like to sort this data
gt; by the description in order to compare the rates. I will be entering more
gt; invoices in the future and would like to avoid having to keep manullay
gt; resorting and reformatting this data that I have been summarizing on sheet 2
gt; quot;Inovice Summaryquot;. On the summary sheet the only data I need to see is the
gt; Description, Qty, Rate and Total.
gt; Also If possible I would like a way to subtotal each sorted decription
gt; groups qty. Any ideas?

--

Dave Peterson