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, 15 views)