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...
Can anyone tell me how to update a validated list automatically just by entering new data into the cell?
Example: If I have a list called servers, how can I add another server to that list?
Thanx
I am trying to create a function that will moved cell content from one sheet to another based on an event.
Example: If D1=Yes, then move the values in A1,B1 and C1 to
sheet2, cells, A1,B1,C1.
I have tried doing an If,then, copy, move etc, with no luck.
I wrote a macro and assigned it to a...
