Results 1 to 5 of 5

A Macro to move rows from one tab to another

This is a discussion on A Macro to move rows from one tab to another within the Excel Questions forums, part of the Question Forums category; Hello everyone, I working with a 4,000 line excel sheet. I need to move certain rows to new tabs and ...

  1. #1
    New Member
    Join Date
    May 2009
    Location
    Canton, OH
    Posts
    31

    Default A Macro to move rows from one tab to another

    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?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: A Macro to move rows from one tab to another

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

    lenze
    If you have to tell your boss you're good with Excel, you're NOT!!
    All I know about Excel I owe to my ignorance!
    Scotch: Because you don't solve great Excel problems over white wine

  3. #3
    New Member
    Join Date
    May 2009
    Location
    Canton, OH
    Posts
    31

    Default Re: A Macro to move rows from one tab to another

    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

  4. #4
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: A Macro to move rows from one tab to another

    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
    If you have to tell your boss you're good with Excel, you're NOT!!
    All I know about Excel I owe to my ignorance!
    Scotch: Because you don't solve great Excel problems over white wine

  5. #5
    New Member
    Join Date
    May 2009
    Location
    Canton, OH
    Posts
    31

    Default Re: A Macro to move rows from one tab to another

    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.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com