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...
Okay...so I have created a data validation sheet and I have it hiden with'in the workbook.
What I would like to be able to do is add to this list from the worksheet itself and have those entires update the hiden data sheet. This way I don't have to hide and unhide the sheet when I need to add...
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
Mike ...again thank you so much....if you like if you e-mail me at this address..david.morrison@abnamro.com, I can send you a copy of the workbook so you can get a clear picture of what I am working on...
David
Okay ...there are two workbooks in this one is a plan, the other is a script. The testplan builds the test script.
The name of the sheet on the testplan is called Technical Resources. The contact name, ext, server and yes/no are in col, b,c,d,e,f respectivly with input beginning at row 3 to row...
WOW!! I think we have struck gold!! Thank you so much for the help this is awsome!!!
This does what I want it to do however...it creates a new sheet...I like this but as a point of advise for me...I have a sheet called technical resources that lists who the resources are for a project and it...
The macro assignment is failing....since it is not a macro just code, I dont have a name for it ..it asks to create a macro it only gives the general not the worksheet so where do I put the code to turn it inot a macro??
Thanx
Okay I have one more question maybe two but for sure one.....how do I assign this code to a command button..the above did not help me..what am I doing wrong??
Okay,
I got it to work by changing a few things:
If Target.Cells.Count > 1 Or Target.Column <> 4 Then Exit Sub
On Error Resume Next
If UCase(Target.Value) = "YES" Then
Application.EnableEvents = False
With ActiveSheet
.Range(.Cells(Target.Row, 1)...
So are you saying modify the code to look for "yes" in column D in the range of d1:dwhatever.....do the same with the other columns and rows correct??
Thanx
Hmm....Okay I have now run into a challenge with this code.
For all practical uses it does work however, I need for it to fill the list downwards. As it is now, it overwrites each entry. I know for most of you this is basic stuff but I am a novice so please forgive me....how do I modify this...
UREEKA!!....Hey it worked...okay so how do I attach it to a button because I want the user to build this list then I want the to go back and press the button so that it will build a contact list for them....
Also, if I understand correctly, this will check gthe entire range in those columns...
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...