I need a form that users can use to enter data into a Excel 2003 spreadsheet in a consistent way. Excel's "Data Form" would work, but I need drop down menus.
My Excel spreadsheet data is organized in several columns. Each row represents a sales prospect. The ~20 columns include... product, part number, customer name, projected sale 2011, 2012, etc., price 2011, 2012, etc.
For ~7 of the columns, I need the form to force users to select entries from a drop down menu.. The rest of the columns just need to be restricted by type (e.g. text entry, currency entry, numeric entry).