A Macro to move rows from one tab to another

[nerojr]

Hello everyone,

I working with a 4,000 line excel sheet. I need to move certain rows to new tabs and then delete the original rows. I recorded a macro that will create and rename 5 new tabs and then move certain rows to the corresponding tab. The macro moves one set of rows and that is all. Is there a different way to move rows to different tabs?

 

[lenze]

If you give us more information(Details) we might be able to help!!
What certain rows?

lenze

 

[nerojr]

I receive a daily worksheet that is around 4,000 lines. I worksheet comes in column headings that I can sort. One of the headings is description and I sort in descending order. I then need to create new tabs for certains descriptions. Right now we copy and paste certain descriptions into the corresponding tab. I need a faster way to accomplish this task. Right now it takes around 45 mins to complete.

Thanks

 

[lenze]

Are you using AutoFilter?? I would think you could do this in a matter of minutes. If you give us more detail we can write a code to do that for you!!
What are the Descriptions?
Are the sheets named the same as the descriptions??
Do you replace previous data on the destination sheet or add to it??

lenze

 

[nerojr]

I do use autofilter to pull out the descriptions I need to move. For example, I filter the description list for anything listed as Incomplete. I then copy this info to the tab I renamed Incomplete. I also do this for the description for Future Term Changes. As for the other tabs, we have descriptions that apply to certain tabs that don't share a name with the tab. An example of this is Raterr Coll - B02 would be moved to the Vin tab. Right now I'm just copying the rows that pertain and pasting them into the appropriate tab. Once the rows are paseted, I then delete the original rows.