Thanks I will try and develop this one
"Debra Dalgleish" wrote:
Dave Peterson has written some instructions for storing entered data:
http://www.contextures.com/xlForm02.html
piper wrote:
Completed that. Now is there a way for me to enter data from the drop down
boxes and save it somewhere and when I click a save button or something it
goes into another spreadsheet and clears the form ready for the next entry,
therefore giving me a completed list of entries for the day on a seperate
spreadsheet?
"Carim" wrote:
Hi,
Two steps :
1. Insert Name Define for your validation list ( say YourListName)
2. Data Validation Allow ... select List, and in the Source field,
just type in
= YourListName
Do not forget the equal sign before the name you have picked ...
HTH
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com