I have a master task list and once I mark the status cell as "complete" I would like it to move to the archive worksheet.
Thanks
Patrick
I have a master task list and once I mark the status cell as "complete" I would like it to move to the archive worksheet.
Thanks
Patrick
Please post some more info
e.g.
Source Sheet Name
Dest Sheet Name
Column of complete
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
No problem. Primary worksheet is "Projects Status", Archive worksheet is "Archive". Status column is in column N. Status can only be a few choices:
Open
Critical
Complete
If the status is "open" then nothing should happen. If "critical" then it will maybe get highlighted or something like that. If "complete" then move to worksheet "Archive".
Thanks a lot.
Using code from this site I done this example.
http://www.rondebruin.nl/copy5.htm#Add
HTH
VBA Noob
Thank you very much it works great. Searching this great forum I found this bit of code as well. How does this compare to how you did it?
Thanks
Patrick
Please Login or Register to view this content.
Looks shorter
However with Ron's it's easy to edit as he has good description on what each line does
VBA Noob
This workded for me also, thank you
I found the answer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks