LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Populating sequentialcombo's or fields

I have a table consisting of three columns , is it possible to populate
the second box dependent on the values in the first box and the third
field dependent on the second selection.

The table is as below:


Make Model Points
DATSUN Other 148
DATSUN Patrol 152
DATSUN Sunny 136
DODGE All Models 200
EUNOS 30X 204
EUNOS 500 208
EUNOS 800 220
FERRARI Berlinetta 320
FIAT 128, 131, 132 180


I have created a unique list of makes , if the user selects Eunos , I
would like the second box to contain the three models and then ideally
the last box to contain the points.

Have tried combo boxes and data validation with no success.

Appreciate any hints/ideas,

Jeff
 
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
how can I convert data with fields in rows to fields as columns PiyushAg Excel Discussion (Misc queries) 3 July 2nd 07 05:46 AM
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! PSSSD Excel Worksheet Functions 2 August 8th 06 09:31 PM
number of fields in the row fields in pivot table UT Excel Discussion (Misc queries) 0 April 13th 06 01:17 AM
Need pie chart with number of fields instead of info in fields Lloyd Pratt Charts and Charting in Excel 1 September 21st 05 11:56 PM
Auto populating fields Mark Excel Worksheet Functions 2 September 15th 05 08:46 PM


All times are GMT +1. The time now is 07:22 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"