If statements using multiple data validations sets

[stuxtruth]

I would like one data validation set for a user to complete.

and then generate a variety of other data sets based on a users input.

Ex: If a user enters Monday- Sunday a different data set is displayed
Monday

red
Blue
Green

Tuesday

Purple
red
Yellow

Weds

White
Black
Green

[ratcat]

G'day and welocme to the forum,

Try this

http://www.contextures.com/xlDataVal02.html

[stuxtruth]

Is it possible to have the data lists on a seperate sheet other then the open work book or import data lists from another spreadsheet. So the user can not see the data lists?

[ratcat]

Hmmm, No

Just simply hide your columns and protect your sheet.

Or

Put all your information on to one sheet and password protect that sheet


Hope that helps


Cheers