| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summarise data on multiple sheets
Hi
I have inherited a invoice workbook which has a sheet for every invoice - currently about 150 sheets.The invoice setup is identical change the data differs. I would like to create a summary sheet which lists the invoice no, date, vendor, nett, vat & gross. All the data is in the same fields on each sheet but the sheet names differ. The field refs are Invoice no = I21, Date = A21, Vendor = D11, Nett = I56, Vat = K56 and Gross = M56. -- Tx Jules |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) | |||
| sumif to add data in multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
