Thread: Filter x and y
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gavmer[_97_] gavmer[_97_] is offline
external usenet poster
 
Posts: 1
Default 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