View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Berglund Jim Berglund is offline
external usenet poster
 
Posts: 41
Default Linked DropDown's

I have two list boxes, A & B. A contains the variables in the left column
(below) ; B contains those in the right column. When a variable from A is
selected, I want to subset the choices in B. And then take specific data
(columns c & D ) about B and enter it into other fields.
A B C D
TRUCKS 1-B 60 1
TRUCKS 1-C 72 2
TRUCKS 1-L 38 3
TRUCKS 1-M 38 5
TRUCKS 1-S 38 7
TRCTRS 2-B 13 3
TRCTRS 2-D 22 2
TRCTRS 2-E 56 4
TRCTRS 2-F 46 5
TRLRS 3-B 102 6
TRLRS 3-D 88 7
AIRSUP 9 65 1
CONST A 23 2
REEFER E 11 4
OTHER Q 5 6
OTHER R 88 9

Could I please get some help with this?

I'm sure this has been asked frequently in the past - and I hate to get
people to do unnecessary work. Is there a website where answers to these
common Excel/VB questions can be just 'looked up'?