N
Neil
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
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