View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kearcomm
 
Posts: n/a
Default 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