Can you make an excel form that has drop down choices and that will save and
clear enabling you to enter the next set of info? if so any advice would be
appreciated. I have done some thing with the drop down lists working but
need to know how to save that record and for it to clear and save in another
spreadsheet or something so a days work can be recorded all from the form?

Yes it can be done using VBA.

For detailed instructions visit
http://exceltip.com/st/Create_User_F...Excel/629.html

"piper" wrote:

Can you make an excel form that has drop down choices and that will save and
clear enabling you to enter the next set of info? if so any advice would be
appreciated. I have done some thing with the drop down lists working but
need to know how to save that record and for it to clear and save in another
spreadsheet or something so a days work can be recorded all from the form?