I need to create an Excel Survey that operators at my manufacturing plant can enter data into daily to populate a database. The survey questions will be:
Todays Date - Would like to use the =today() formula
Part Number - Will require data validation from a selected list of part numbers
Defect Type - They can choose one or more; cracked, split, bent, dimensional
Area - Will require radio button for one choice; production, quality, shipping
The operators will continuously be answering this survey throughout the day. The survey needs to populate an excel sheet one line item at a time. Basically a database.
Can I do this easily or do I need to learn VBA or MS Access? Or just move our platform to Google Docs for this specific task? I want it in Excel, preferably.
Bookmarks