Filter x and y

[gavmer]

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

 

[Charles]

gavmer,

Here is something I came up with. Hope it works for you.

Charle