If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get a Data validation list to select another validation l
I am creating a data entry page in which I want to use data validation Lists
to select the product that I want to enter. How ever each cell may be different from the one above. For example in (c4) I want to enter pipe data. I have a sheet named pipe as the source for this entry. In (c5) I want to enter valve data or maybe pipe data or ell data. How can I use Excel to create a drop down list that lets me decide which source page I want to use and then go to it for me to make my selection? |
#2
|
|||
|
|||
How do I get a Data validation list to select another validation l
Hi
Look at this site: http://www.contextures.com/xlDataVal02.html Regards, Per "langston35" skrev i meddelelsen ... I am creating a data entry page in which I want to use data validation Lists to select the product that I want to enter. How ever each cell may be different from the one above. For example in (c4) I want to enter pipe data. I have a sheet named pipe as the source for this entry. In (c5) I want to enter valve data or maybe pipe data or ell data. How can I use Excel to create a drop down list that lets me decide which source page I want to use and then go to it for me to make my selection? |
Thread Tools | |
Display Modes | |
|
|