J
Jeff Mackeny
Hi, I'm trying to setup a validation (Drop Down) list that would
automatically add new entries to the list upon approval from the user, in
other words, ill setup a warning that would say 'entry does not exist, would
you like to add now', user clicks Ok and its added to the list, also this
should work for all cell with a drop down for a specific list, for example
it will take new entry from any cell A1:A300 (assuming of course that
A1:A300 are pointing to the same list), the same if the user deletes
something from cell A1:A300 it should prompt the user 'Are you sure you want
to remove this entry', user click Ok and the entry is removed from the list.
Thanks
automatically add new entries to the list upon approval from the user, in
other words, ill setup a warning that would say 'entry does not exist, would
you like to add now', user clicks Ok and its added to the list, also this
should work for all cell with a drop down for a specific list, for example
it will take new entry from any cell A1:A300 (assuming of course that
A1:A300 are pointing to the same list), the same if the user deletes
something from cell A1:A300 it should prompt the user 'Are you sure you want
to remove this entry', user click Ok and the entry is removed from the list.
Thanks