How do I link one cell to a range of cell with a drop-down menu?
 

I am trying to link one series of cells to a series of cells on another
workbook or a database. I have a purchase order worksheet that has a "Product
Description" Column, "Part Number" column and a "Unit Price" column and I
would like to link these columns to a access database or table using a
drop-down menu. Please advise what is the best way to do this.

Thank You in Advance

How do I link one cell to a range of cell with a drop-down menu?
 

For the first column you could use a drop down list using data
validation

http://exceltips.vitalnews.com/Pages...Down_List.html

then the other two columns you could use vlook up

http://www.599cd.com/Free/VLOOKUP/?k...LOOKUP&CPC=0.2


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523985

How do I link one cell to a range of cell with a drop-down men
 

Thank You

"davesexcel" wrote:


For the first column you could use a drop down list using data
validation

http://exceltips.vitalnews.com/Pages...Down_List.html

then the other two columns you could use vlook up

http://www.599cd.com/Free/VLOOKUP/?k...LOOKUP&CPC=0.2


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523985