Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
Hi Trying to make a drop down list in excel. I have tried the validation
method and cannot seen to get the path correct. I have a speadsheet with say 7 worksheets the first being the main one the rest hold individual data that I want each cell in the 1st table to look up and give me the choice of entering individual items from the drop down. What I tried to do was in the Validation screen selected List but cannot figure out the source info to enter I have tried =Area!A1:A5 but does not got to sheets 2 called Area and give me a drop down choich of the data help in cells A1 to A4. Any advice would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
I have now completed the set up as you suggested and used the template. I
now have an Input form, Dtasheet and Lookuplist. Please can you advise how I can add new itemes to the lookuplist I have 3 columns in the lookuplist sheet a, b and C and need to know how I can add items so as they will show on the drop down lists in the input form. Your kind help would be very much appreciated "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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
You can create named ranges, as described he
http://www.contextures.com/xlNames01.html Then, use those names in the data validation drop downs, as described he http://www.contextures.com/xlDataVal01.html piper wrote: I have now completed the set up as you suggested and used the template. I now have an Input form, Dtasheet and Lookuplist. Please can you advise how I can add new itemes to the lookuplist I have 3 columns in the lookuplist sheet a, b and C and need to know how I can add items so as they will show on the drop down lists in the input form. Your kind help would be very much appreciated "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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down
Thanks, I will sit and try to get this to work and let you know
Bruce "Debra Dalgleish" wrote: You can create named ranges, as described he http://www.contextures.com/xlNames01.html Then, use those names in the data validation drop downs, as described he http://www.contextures.com/xlDataVal01.html piper wrote: I have now completed the set up as you suggested and used the template. I now have an Input form, Dtasheet and Lookuplist. Please can you advise how I can add new itemes to the lookuplist I have 3 columns in the lookuplist sheet a, b and C and need to know how I can add items so as they will show on the drop down lists in the input form. Your kind help would be very much appreciated "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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |