LinkBack URL
About LinkBacks
I have created a list in a one workbook and in another workbook I added a data Validation list and set the error to stop.
But when I edit the cell I don't get the error message?
I have created a list in a one workbook and in another workbook I added a data Validation list and set the error to stop.
But when I edit the cell I don't get the error message?
Last edited by CityMPLSEmpolyee; 01-10-2012 at 01:01 PM.
Validation list would work better if the list is in the same sheet, try by linking the original validation list somewhere where the sheet report is, make this list the validation one and then hide these cells, is not what you are asking for but it works....
C
You can most certainly have the List on another sheet and using a named range is entirely appropriate. Try unselecting "Ignore Blank" in your Data Validation setup.
You may want to research "Dynamic Named Ranges".
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
jaslake
Thanks for your help
Unselecting "Ignore Blank" worked
CarlosAndres
Thanks for your help as will
What you said does work and may be the better way to build the spread sheet,
But I needed to reserve the rest of the worksheet for future data processes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks