On Feb 27, 7:26*pm, Neil wrote:
Hi,

I currently have a sheet that has 20,000 + lines of data.

If the cell data on each row matches two different criteria, i want to
be able to cut the row and paste it into a different sheet tab on the
next available row.

As there are 20000 + rows of data and none of it is sorted i would
prefer not to use the autofilter and move every few lines (There are
multiple sheet tabs which i need to move data to). I also have
multiple others things happening within the macro, so would
incorporate this step into it.

Any help would be greatly appreciated.

Thanks
Neil

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."