How to setup a budget sheet with all suppliers and purchases on one sheet.

Hi everybody,

this is my first post and by looking at your reply's I have come to the right place.

I am trying to find out how to go about making a sheet that will allow budgets to be managed on a single sheet. Staff will enter in the details in the lower half and the amounts are automatically deducted from the relevant budgets in the top section. Just to complicate things a bit further, new suppliers will be added from time to time.

I hope I have attached a very basic sample of what I mean!

Thank you for any advice,

Happy New Year to you all.

Mannxy