add totals via drop down menu

Originally Posted by excellentexcel

nbvc
if we say the sheet is clean
is there any way in which you can set a default into the qty cell (cell c3) of 1 if an entry is made into cell b3 and the user can over ride if needs be?

regards

Once you overwrite it, it won't go back unless you are using this as a template and only want the 1's at the start and don't care if users change as long as you have the template..... Then you can use formulas....

But...I think you'll be better off with a VBA worksheet Event macro for that...

Post the question separately in the Programming forum.