Data Validation Lists

[dmorri254]

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

 

[msmith]

David,

I'm trying to put something together for you, but may take me a couple of days.

Regards,
Mike

 

[msmith]

David,

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

 

[50gumbys]

Hi!
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

 

[crablare]

Hi,
Msmith, could you send me the demo as well.

 

[msmith]

Lori & crablare,

I need your email addresses!



Regards,
Mike

 

[Planet]

hi Msmith,

Could i have a copy of the demo too?
you can send to planet2earth2000@yahoo.com

Thanks

 

[50gumbys]

Sorry about the delay - I was out of town and swamped by crocodiles!
Please email me at lch1950@icqmail.com
Many, many thanks!!!!

 

[karaeloko]

Hi would you send the demo workbook to me?. My email is yellowman08@hotmail.com... thx in advance

 

[aobjr]

MSmith,

I'm interested in your demo. Thanks in advance.

email address :aobautista@bhpi.com.ph