Cutting row data and pasting into next available row on different tab

[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

 

[Bob Flanagan]

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

 

[Donald Guillett]

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."