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.