On Feb 27, 8: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

Neil, one approach to consider is to construct a formula in a third
column that returns the name of the sheet where the data is to go.
Then sort the data and cut and paste each block. Far faster than a
few lines at a time.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel