Data Validation Lists
Data Validation Lists
(OP)
Hello again,
I have a hidden worksheet that contains data used in validation lists.
Now what I would like to do is set it up to where if the users needs to add another item to that list, he can enter it directly into the list without having to unhide the sheet or ask me to update the list for him/her.
Can someone please show me how to code this so the user can update the list for themselves and have the data flow inot the correct named list in hidden sheet?
Thanx so much
David
I have a hidden worksheet that contains data used in validation lists.
Now what I would like to do is set it up to where if the users needs to add another item to that list, he can enter it directly into the list without having to unhide the sheet or ask me to update the list for him/her.
Can someone please show me how to code this so the user can update the list for themselves and have the data flow inot the correct named list in hidden sheet?
Thanx so much
David





RE: Data Validation Lists
I'm trying to put something together for you, but may take me a couple of days.
Regards,
Mike
RE: Data Validation Lists
If you are monitoring this thread, I have sent you a demo workbook. If anyone else is interested, I'd be happy to send you a copy, also.
Regards,
Mike
RE: Data Validation Lists
I'm new here; but I just read this thread and I too, would very much like to know how to add a new item to a list.
I'd appreciate getting a copy too.
Many thanks!
Lori
RE: Data Validation Lists
Msmith, could you send me the demo as well.
RE: Data Validation Lists
I need your email addresses!
Regards,
Mike
RE: Data Validation Lists
hi Msmith,
Could i have a copy of the demo too?
you can send to planet2earth2000@yahoo.com
Thanks
RE: Data Validation Lists
Please email me at lch1950@icqmail.com
Many, many thanks!!!!
RE: Data Validation Lists
RE: Data Validation Lists
I'm interested in your demo. Thanks in advance.
email address :aobautista@bhpi.com.ph