Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
extracting comma seperated from a single cell and auto populating in selected cells o | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |