Pull down cell to access n&a spreadsheet
 

Short version: I am creating a Sales Order form. My salesman has
several hundred customers in a spreadsheet. I would like to create a
pull down cell on my Sales Order spreadsheet that will allow him to
access the name column from his spreadsheet, when he selects a specific
name, the address (shown in columns B, C, etc.) should fill in the 2 or
3 cells beneath the name.
I cannot figure is this is a hyperlink or Validation?
Never have done it before.
Any direction would be appreciated.


--
bankprofessor
------------------------------------------------------------------------
bankprofessor's Profile: http://www.excelforum.com/member.php...o&userid=26415
View this thread: http://www.excelforum.com/showthread...hreadid=396850

Validation for the name column and vlookups for the other columns.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"bankprofessor" wrote:


Short version: I am creating a Sales Order form. My salesman has
several hundred customers in a spreadsheet. I would like to create a
pull down cell on my Sales Order spreadsheet that will allow him to
access the name column from his spreadsheet, when he selects a specific
name, the address (shown in columns B, C, etc.) should fill in the 2 or
3 cells beneath the name.
I cannot figure is this is a hyperlink or Validation?
Never have done it before.
Any direction would be appreciated.


--
bankprofessor
------------------------------------------------------------------------
bankprofessor's Profile: http://www.excelforum.com/member.php...o&userid=26415
View this thread: http://www.excelforum.com/showthread...hreadid=396850