Move rows to different worksheet that meet certain criteria

**pstritt** · 09-25-2007, 03:26 PM

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

**VBA Noob** · 09-25-2007, 03:31 PM

Please post some more info

e.g.
Source Sheet Name
Dest Sheet Name
Column of complete

VBA Noob

**pstritt** · 09-25-2007, 03:37 PM

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.

**VBA Noob** · 09-25-2007, 03:53 PM

Using code from this site I done this example.

http://www.rondebruin.nl/copy5.htm#Add

HTH

VBA Noob

**pstritt** · 09-25-2007, 04:30 PM

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.

**VBA Noob** · 09-25-2007, 04:32 PM

Looks shorter

However with Ron's it's easy to edit as he has good description on what each line does

VBA Noob

**panagle** · 01-25-2013, 02:44 PM

This workded for me also, thank you

**panagle** · 01-25-2013, 02:50 PM

I found the answer

Move rows to different worksheet that meet certain criteria

LinkBack

Thread Tools

Rate This Thread

Display

Move rows to different worksheet that meet certain criteria

Re: Move rows to different worksheet that meet certain criteria

Re: Move rows to different worksheet that meet certain criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions