Thread: How do I get a Data validation list to select another validation l
View Single Post
  #2  
Old September 28th, 2009, 08:38 AM posted to microsoft.public.excel.newusers
Per Jessen
external usenet poster
  
Posts: 686
Default 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?