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
|