Dynamic data

[Derek Witcher]

I am trying to populate a excel spreadsheet with another spreadsheet.
What I am looking for is using the validator to create a drop down
menu with all other my item numbers in it. After you use the pull
down to select an item all other data that is on the same row will
populate the specific fields. Much like the datasource when you do a
mail merge with excel and word. Any suggestions or ideas would be
greatly appreicated.



Thanks in advance for the help.

 

[Tom Ogilvy]

look at help for Data=>Validation. You would need to create a defined name
(Insert=>Name=>Define) for the column of item numbers. Assume the name you
assign is List1. Then in Data=>Validation, select List, then the source put
in =List1

Now in the cells next to where the data validation is applied (Assume A3),
put in formula like

=if(A3="","",Vlookup(A3,Sheet2!$A$1:$J$200,2,false) )

the 2 says get the second column in the range Sheet2!$A$1:$J$200 change
it to 3 to get the 3rd column (C in this case). and so forth.