Is there a way to have a user on sheet1 pick from a pull down of a data validation on sheet2? I have important information that is linked to only sheet2 within a data validation. I want to be able to reference it in sheet1 to have the user pick, then it toggles them on sheet2. Is this possible?
-
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.
Toggleing Data validation Cells from another worksheet
- Thread starter Mstg007
- Start date
pbornemeier
Well-known Member
- Joined
- May 24, 2005
- Messages
- 3,910
I don't fully understand your requirement. If the following does not answer your question, please restate your requirement.
If you use a named range to define the list for your data validation, you can use that named range for data validation on any page of that workbook.
If you use a named range to define the list for your data validation, you can use that named range for data validation on any page of that workbook.
Upvote
0
I was wanting the user to beable to pick from an already setup data validation on sheet 2 from sheet 1. The more I think about it; it would prob. be easier just to move the data validation to sheet1 and then the result be linked over to sheet2.
Upvote
0
