+ Reply to Thread
Results 1 to 5 of 5

Moving Rows from Multiple Sheets to a New Sheet

  1. #1
    Registered User
    Join Date
    12-07-2018
    Location
    Malta
    MS-Off Ver
    2013
    Posts
    2

    Lightbulb Moving Rows from Multiple Sheets to a New Sheet

    Hi Guys! I hope you are all doing well!

    I was hoping if you could help me with the idea I have for my sheet which should be quite simple but I can't seem to find any guides online.

    Basically I have this Sheet with a:
    • Homepage
    • Surrenders
    • Lapsing
    • Maturities
    • Settled

    Now what I want is, to create a button on the homepage sheet and assign a macro to it. I want this macro to move all rows from sheets Surrenders, Lapsing and Maturities that have Status (Column F) set as "Handed to Finance" to the sheet Settled.


    Would you please be able to help me? Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,496

    Re: Moving Rows from Multiple Sheets to a New Sheet

    Please Login or Register  to view this content.
    You have capital and non capital letters so Option Compare Text at the top will take care of that.

  3. #3
    Registered User
    Join Date
    12-07-2018
    Location
    Malta
    MS-Off Ver
    2013
    Posts
    2

    Re: Moving Rows from Multiple Sheets to a New Sheet

    That's awesome man, thank you so much! Sorry to be a pain but I forgot to mention two important factors. The rows from "Surrenders", "Lapsing" and "Maturities" need to be deleted after moved. Would that be possible?

    Also, would it be possible to add multiple values in the "If c.Value"? My point is..to move all rows that have the below status (not only Handed to Finance):
    • Handed to Finance
    • Lapsed
    • Filed Away
    • Paid

    Thanks a real lot

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,496

    Re: Moving Rows from Multiple Sheets to a New Sheet

    Looping is not the fastest way. Depends on the amount of data you need to go through.
    Try this maybe.
    Keep the "Option Compare Text" from the previous post as is.
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,496

    Re: Moving Rows from Multiple Sheets to a New Sheet

    I saw that you worked with Autofilter allready in your code.
    You could try this also.
    Please Login or Register  to view this content.
    BTW, in the future when you attach a workbook, make sure that no sheets are protected.
    It does not matter in this case but rather not.
    Last edited by jolivanes; 12-08-2018 at 01:46 AM. Reason: Fix Dims

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 01-04-2016, 01:42 PM
  2. Moving rows of data to multiple sheets based on status for project pipeline
    By sthiessen85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2015, 08:55 AM
  3. [SOLVED] Moving rows of data to multiple sheets based on status
    By sthiessen85 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2015, 01:21 PM
  4. Moving rows from multiple worksheet to one master sheet.
    By skittlies07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2012, 12:26 PM
  5. [SOLVED] Copy range from multiple sheets, into a master sheet and moving over by variable col range
    By g1eagle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2012, 01:36 PM
  6. Replies: 8
    Last Post: 11-20-2011, 09:48 AM
  7. Replies: 3
    Last Post: 09-29-2005, 07:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1