Hi guys, I hope someone can help with this one.
Basically I want to creat a simple "front end" data input sheet
that has a series of drop down boxes and a dollar value input cell.
The user will go thru the various fields drop downs and then enter a dollar amount, .
There will then be an "ENTER" button which would trigger the macro.
This would take the dollar value and enter it into the relevant column on another worksheet.
Also, the next time that value is selected etc, the value would then be copied to the next cell down, so that there will be a running total of the variable.
I have attached a basic worksheet so you might be able to figure out what i am trying to do.
Thanks in advance