Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cumulatively list data from each new worksheet
I have a very simple system for generating invoices where I have one
worksheet as the invoice template, and then for each new invoice I copy that template to a new worksheet, rename that worksheet with the new invoice number, and use a formula to copy that sheetname to the relevant "InvoiceNo." cell on the new worksheet. In other words, each invoice is a separate worksheet, with the invoice number matching the worksheet name. I then type in the relevant details for the new invoice and the invoice total gets calculated. The cell addresses for four key values on each invoice (same on every invoice/worksheet) are InvoiceNo: E5 InvoiceDate: E6 ClientName: B10 InvoiceTotal: F38 So far this suits me fine (there are seldom more than four or five invoices per month). But what I would like to do now is have an additional summary worksheet (in the same workbook) which stores a cumulative list of the key data from each invoice/worksheet, automatically adding a new row for each new invoice/worksheet as it it created, with columns for InvoiceNo, InvoiceDate, ClientName, and InvoiceTotal respectively. It would relatively straightforward for me to set this up this as a simple database in Access but I'm sure that what I want is also a simple matter in Excel. I just can't figure out how to go about it. Any help would be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need data from one worksheet to be in a list in another worksheet. | Excel Discussion (Misc queries) | |||
Using list of data in another worksheet | Excel Worksheet Functions | |||
Data validation list from another worksheet? | Excel Discussion (Misc queries) | |||
how do i cumulatively add in a single column? | Excel Worksheet Functions |