Tweak my macro, is there a way to have it move only filtered items?

Hey all,

So I have this macro that moves data from one column to the top of another and removes data from the original. My scope has changed a bit and I was wondering if there was a way to tweak it so that it would only move filtered or selected items.

For example, my spreadsheet is roughly 1000 rows. I get comments from another team, but of the 100 or so comments that I need to move weekly 80 of them offer no real value so it's strictly me moving them. What I would like to do is filter for those 80 and move them leaving the 20 or so that I actually need to pay attention to.

Here's the code I am currently using, it works perfectly, just wondered if it could be better.

I am running Office 2007 and using xlsx files if that makes a difference.

Please Login or Register  to view this content.

[QUOTE=protonLeah;2731909]Well, since your posted code does not autofilter, you might do something like this:

Thanks Ben, I have not forgotten about this, just been too busy to test it.

Would this code go in front of what I am already using?