I have 8 lists of data in columns F1-13 through M1-13. What I need to do is make a data validation list in column C and D. Column C should be able to select ANY of the data from the 8 columns, Column D needs to be dependent on column C. If the data in column C is from column F or G then the data in column D can not be from F or G but can still be from the other 6 columns. Is that understandable? Any help?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data Validation dependent on another selection. Excel 2010, Windows 10.
Similar threads
