LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
beel
 
Posts: n/a
Default 6 Data Validation lists depending on 1 cell value

In have been looking over Debra Dalgleish's info (great stuff there)
and the advanced newsgroups but can't seem to find an answer to my
problem.

I have one validation box with 6 manufacturers in it, there are then 6
other cells with data validation in which depend on the value chosen in
the first cell. i.e. (in short)

Maker aaa bbb ccc
aaa part a part a part b
bbb part b part g part f
ccc part f part h part h

Indirect only links to first, I think I need offset but cannot work it
out, (comes of being old I suppose). I'm sure I am missing something
straightforward.
Any help would be much appreciated
Regards
Bill

 
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
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Data Validation DLM Excel Discussion (Misc queries) 2 February 22nd 05 02:26 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
Data Validation Formula Help Steve H. Excel Worksheet Functions 2 November 11th 04 09:38 PM
data validation on sth else [email protected] Excel Worksheet Functions 1 November 3rd 04 01:52 PM


All times are GMT +1. The time now is 10:10 PM.

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"