View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil[_34_] Neil[_34_] is offline
external usenet poster
 
Posts: 3
Default Cutting row data and pasting into next available row on different tab

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