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!!!!

Need a Drop Tab that when selected, auto filters info to a cel
 

Thanks it does have what I need, but I'm unable to duplicate it. There codes
contained in the tabs that I can not make work for my spreadsheet. I guess I
have to just keep playing around with it until I get it right.

Much Thanks,
Armando

"Randy L" wrote:

Saw this link posted in this group a few days ago. Very good stuff.

http://www.contextures.com/xlDataVal02.html

"Armando" wrote:

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!!!!