Excel Form

[simon4sam]

How would i go about designing a form in Excel so that when someone enters the details below, it automatically generates the data on a separate worksheet. eg One person inputs a record, then a day later someone else add another etc.

I am possibly looking at making this a form to be used on a local intranet.


Autonumber, Autonumber, Unique
Area, Drop Down from Editable list, Unique
Region, Drop Down from Editable list Unique
Name of Auditor, Drop Down from Editable list Unique
Date of Audit, Date Field, Unique
Item Manufacturer, Drop Down from Editable list Can have multiple
Number of items reviewed, Value Field Can have multiple
Number of items contaminated, Value Field Can have multiple
Number of Items with Surface Issues, Value Field Can have multiple
Question 1, Yes, No Unique
Question 2, Yes, No,, Unique
Question 3, Yes, No, Unique
Question 3 ,Yes, No, Unique
Comments, Free Text, Unique

[BigBas]

Truthfully, the quickest and easiest solution is to use the built in form wizard. This approach provides the least functionality, and will not allow drop downs, validations, etc. The link for this method is here: http://spreadsheets.about.com/od/exc..._data_form.htm

Another approach is to actually build a userform. This will require some VBA knowledge, and a time investment. Here is a good beginners guide. http://www.contextures.com/xluserform01.html

[royUK]

See the DataBaseForm here