Hi All,


I have a spreadsheet to help me keep track of money that is being spent. Each spreadsheet will have a different PO Number as shown on the attached test sheet under D2 and a total amount of money available under D3.

I have set up a formula which you can see on the workbook that i have attached, and set up a formula so that when an amount is entered in columns F, G, H, I, J, then it shows the remaining total in column K.

As i will have many PO numbers and money to keep track of in seperate workbooks, is there a way i can have a workbook which will list all the PO numbers and next to them will show the remaining total for each PO number, and every time i update it on the workbooks then it will update on the PO number list so that i can keep track of remaining amounts without having to go into every workbook

Hopefully this all makes sense

Any help will be appreciated

Thanks

Attached Files

Book1.xlsx (15.4 KB, 13 views)

Your attached workbook gives very little for anyone to work with. There are no column headings, no indication of how the data might be related to what's in the other workbooks, etc.

In any event, you'd do far better setting up an Access database for this kind of thing.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]