View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 271
Default selecting from dropdown--have related info auto carry over

I've created drop box for my project--I need to have all relevant info to
automatically carry over as well.

In sheet 3 i have my lists: Item#, Description, Price (all in seperate
cells)
In sheet 1 i have the dropdown set up.

When I select an Item number, how do I make sure the description and price
automatically carry over with it in their respective cells?

Thank You

Susan Christenson