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?

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?