Subtract cells from data entered and display result in active cell.

OK I have attached an example, a simplified version of what I am trying to accomplish. Basically I want to enter the total sales number in B1 and have it automatically subtract the amounts for surcharge(B2), tooling(B3), and pallets(B4); to display the product sales dollars in B1. Is this possible or do I need to add a totally separate row for total sales?

I wasn't real sure how to word the title so any suggestions and I will edit.

thanks.

You could add a worksheet change event into the sheet object of the vba project:

Please Login or Register  to view this content.

Do you want it to be an auto updating value (ie you can still have changes in B2-B4 which will affect B1), or do you want it so that once you enter a value into B1 it calculates and that is it. I guessed the latter so here you go:

Please Login or Register  to view this content.

Well yes I would like the value to change as I enter the data in B2-B4. So in case there was an error and I need to go back and change the pallet amount, for example, the total in B1 would change also.

You should just have a separate row for total sales then.