Thread: How to link a drop down value to a cell in a different worksheet?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cdkjpm cdkjpm is offline
external usenet poster
  
Posts: 1
Default How to link a drop down value to a cell in a different worksheet?
I have two Excel sheets in the same Workbook. Sheet 1 has a description in
one column and the listing price in another column. I need to know how to
link those two columns together so when I create my drop down list in Sheet 2
it will automatically bring over the Price from sheet 1 to sheet 2.
(Worksheet 2 has a dropdown list of all of my items from sheet 1).
Reply With QuoteReply With Quote