Hi Please open the file attached it explains it all there....
It is for a Project.
I need to track invoices coming in and these are the most relevant columns I want automated.
Region/Building- Project Categories - Allocated $- Remaining $
As I enter an invoice, I select the Region, then the Category from drop down lists, I then have entered a formula in the Allocated column for when a category is selected the coinciding Allocated $ is listed.
Now what I want which I don't know if it is possible, is in the Remaining cell I want it to look at the Category's allocated amount and deduct the amount of the invoice and enter the remaining $. But then as invoices are entered if that same category is selected then I want it to remember the remaining amount from before and deduct from that to then give me the remaining $
It will make more sense in the worksheet.
Thank you - any assistance is greatly appreciated
It is for a Project.
I need to track invoices coming in and these are the most relevant columns I want automated.
Region/Building- Project Categories - Allocated $- Remaining $
As I enter an invoice, I select the Region, then the Category from drop down lists, I then have entered a formula in the Allocated column for when a category is selected the coinciding Allocated $ is listed.
Now what I want which I don't know if it is possible, is in the Remaining cell I want it to look at the Category's allocated amount and deduct the amount of the invoice and enter the remaining $. But then as invoices are entered if that same category is selected then I want it to remember the remaining amount from before and deduct from that to then give me the remaining $
It will make more sense in the worksheet.
Thank you - any assistance is greatly appreciated