View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Linking Data for Proposal

I am trying to link data in the 2nd worksheet called Equipment to the 1st
worksheet called Quote.
In the Equipment worksheet I have 3 columns of data that are related. The
first column is item, the second column description and the third column is
price. I am looking for a way to bring that data onto the 1st worksheet
called Quote. I believe I want to use the drop down method, but have not
been able to get it to work. When I do the drop down I want all 3 fields
moved to the row in the 1st worksheet.