Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
invoices with summary...where to start
I have downloaded one of the simple MS templates.
Use it daily, manually renumbering each invoice. At the end of the month I create a separta summary adding them all up by client...i.e. multiple summaries. Is there some way that Excel can be automated to do the summary by client? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
invoices with summary...where to start
Here's one way to do it. I have summary in sheet 1 and data of clients in
sheet 2. In sheet 2, for ex. A B 1 Client 1 Invoice # 1 2 Client 1 Invoice # 2 3 Client 1 Invoice # 3 4 Client 2 Invoice # 1 5 Client 2 Invoice # 2 6 Client 2 Invoice # 3 For this example, in sheet 1, I will put the following formula A1 =COUNTIFS('sheet 2'!A1:A3,"Client 1") B1 =COUNTIFS('sheet 2'!A3:A4,"Client 2") You could tweek it to suit your need. Tina "I Am Cdn" wrote: I have downloaded one of the simple MS templates. Use it daily, manually renumbering each invoice. At the end of the month I create a separta summary adding them all up by client...i.e. multiple summaries. Is there some way that Excel can be automated to do the summary by client? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
invoices with summary...where to start
Sorry, made a mistake! You could actually count the whole column of clients for the different client names. So you could put, A1 =COUNTIFS('sheet 2'!A:A,"Client 1") B1 =COUNTIFS('sheet 2'!A:A,"Client 2") Tina "T.C" wrote: Here's one way to do it. I have summary in sheet 1 and data of clients in sheet 2. In sheet 2, for ex. A B 1 Client 1 Invoice # 1 2 Client 1 Invoice # 2 3 Client 1 Invoice # 3 4 Client 2 Invoice # 1 5 Client 2 Invoice # 2 6 Client 2 Invoice # 3 For this example, in sheet 1, I will put the following formula A1 =COUNTIFS('sheet 2'!A1:A3,"Client 1") B1 =COUNTIFS('sheet 2'!A3:A4,"Client 2") You could tweek it to suit your need. Tina "I Am Cdn" wrote: I have downloaded one of the simple MS templates. Use it daily, manually renumbering each invoice. At the end of the month I create a separta summary adding them all up by client...i.e. multiple summaries. Is there some way that Excel can be automated to do the summary by client? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
invoices with summary...where to start
If you are using one of the Templates from Office Template Gallery I would
assume that each invoice is in its own separate workbook. Is this correct? If not, describe your scenario. You may find some answers to automation at Ron de Bruin's site under the Copy/Paste/Merge section. http://www.rondebruin.nl/tips.htm Gord Dibben MS Excel MVP On Wed, 7 Oct 2009 10:40:12 -0700, I Am Cdn wrote: I have downloaded one of the simple MS templates. Use it daily, manually renumbering each invoice. At the end of the month I create a separta summary adding them all up by client...i.e. multiple summaries. Is there some way that Excel can be automated to do the summary by client? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Start spreadsheet with WinXP start | Excel Worksheet Functions | |||
Excel invoices and automated summary | Excel Discussion (Misc queries) |