Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter x and y
Hi all, Imagine this CONFIG r1 r2 r3 r4 COL 11 200 NA NA 400 22 NA NA NA NA 33 NA NA NA NA 44 500 400 500 900 This is the way my data is presented. I have a list of around 40 part and each part has this price structure attached. "Config" is col F- and "COL" 11-44 exists for each part. Total of around 300 rows. F-I an all rows is range called "PRICING" What im trying to achieve is to have a user form on opening with 2 combo boxes "CONFIG" and "COL". If user selects r2, then columns r1,r and r4 clear. They may then choose COL 22 from second combo box. If so then all the info to the RIGHT of rows containing 11,33,44 clears leaving only the rows 22. Basically a filter x and y axis so the info you are left with would b r2,22 which would be NA. (Imagine config as columns and col a rows.....sorry, my formatting changed when posted) PPPPLLLLEEEAAAASSSEEEE HELP ME!!!!!!! Am happy to show exampl -- gavme ----------------------------------------------------------------------- gavmer's Profile: http://www.excelforum.com/member.php...nfo&userid=666 View this thread: http://www.excelforum.com/showthread.php?threadid=27102 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter x and y
gavmer, Here is something I came up with. Hope it works for you. Charle -- Charle ----------------------------------------------------------------------- Charles's Profile: http://www.excelforum.com/member.php...nfo&userid=601 View this thread: http://www.excelforum.com/showthread.php?threadid=27102 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
How to set multiple filter values for a filter in the page fields | Excel Programming |