LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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'?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked spreadsheets failing to recognised that the linked file is Michael Excel Discussion (Misc queries) 0 January 14th 10 12:03 PM
Sorting non-linked cells in a linked worksheet Gary Excel Discussion (Misc queries) 1 October 25th 08 03:38 AM
How do I have a linked cell auto-size to fit the linked data? CristinPDX Excel Discussion (Misc queries) 0 June 24th 08 08:42 PM
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
In a linked calculation how do I lose the '0' in the linked file? Anita Excel Worksheet Functions 2 February 3rd 06 01:54 PM


All times are GMT +1. The time now is 08:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"