View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Armando Armando is offline
external usenet poster
 
Posts: 21
Default Need a Drop Tab that when selected auto filters info to a cell!!!

I have created a spread sheet in which has standard pricing for standard
products. Each row has a drop tab cell in which lists standard sizes. How do
I make a cell link according to what is selected in the "Validation List
box". It needs to work so that if I select a 18" box from the drop down tab
the cell under "Price" changes to that size. I know it sounds confusing, I
can clarify if needed.