+ Reply to Thread
Results 1 to 12 of 12

How to move rows based on cell value to multiple tabs?

  1. 08-11-2020, 08:54 PM #1
    AccountingJ
    AccountingJ is offline
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    How to move rows based on cell value to multiple tabs?

    Hi everyone I have the macro below that works well. I just need to expand on it and need some guidance.

    It currently moves data found in sheet 1 to sheet 2 if the values in column F = "Y". First, I would like the formulas on columns F:I to be copied to the last cell with data. Then, I need more conditions, for example if any cell in column "G" = No Issues Found, move to sheet 3, if cells in column "H" = Review then move to sheet 4 and if the cell in column "I" equals "Test Fail" then move to sheet5.

    Biggest issue I'm thinking is that some rows MIGHT need to be in multiple tabs but everything I found in Google deletes the row once it meets the first criteria.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by AccountingJ; 08-17-2020 at 12:57 PM.
    Reply With QuoteRegister To Reply
  2. 08-12-2020, 02:55 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,341

    Re: How to move rows based on cell value to multiple tabs?

    Hi AccountingJ...
    As an example...See attached file...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 08-12-2020 at 08:47 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 08-12-2020, 12:38 PM #3
    AccountingJ
    AccountingJ is offline
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to move rows based on cell value to multiple tabs?

    Wow, thanks, works well.

    Only thing, is that the sheets names need to be named sheet2, sheet3, etc...
    Reply With QuoteRegister To Reply
  4. 08-12-2020, 01:23 PM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,341

    Re: How to move rows based on cell value to multiple tabs? 

    Please Login or Register  to view this content.

    Thanks for rep by the way...
    Reply With QuoteRegister To Reply
  5. 08-17-2020, 01:56 PM #5
    AccountingJ
    AccountingJ is offline
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to move rows based on cell value to multiple tabs?

    I had to add more columns and pushed back the formulas back to range T2:AA2 and also added some tabs.

    I made the changes to your macro, see below:

    Please Login or Register  to view this content.
    The macro runs but does not transfer over the data like it did before, what other changes do I need to do to it?
    Attached Files Attached Files
    Last edited by AccountingJ; 08-17-2020 at 02:15 PM.
    Reply With QuoteRegister To Reply
  6. 08-17-2020, 02:11 PM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,341

    Re: How to move rows based on cell value to multiple tabs?

    The macro runs but does not transfer over the data like it did before, what other changes do I need to do to it?
    Will only be able to ascertain issue once I see the file...
    Reply With QuoteRegister To Reply
  7. 08-17-2020, 02:16 PM #7
    AccountingJ
    AccountingJ is offline
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to move rows based on cell value to multiple tabs?

    Quote Originally Posted by sintek View Post
    Will only be able to ascertain issue once I see the file...
    Sorry, I forgot to attach. Please see above.
    Reply With QuoteRegister To Reply
  8. 08-17-2020, 02:20 PM #8
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,341

    Re: How to move rows based on cell value to multiple tabs? 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 08-17-2020, 02:24 PM #9
    AccountingJ
    AccountingJ is offline
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to move rows based on cell value to multiple tabs?

    thanks, what does the 20 do? that's the only change I see.
    Reply With QuoteRegister To Reply
  10. 08-17-2020, 02:27 PM #10
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,341

    Re: How to move rows based on cell value to multiple tabs?

    Changes in red...
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 08-17-2020, 02:34 PM #11
    AccountingJ
    AccountingJ is offline
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to move rows based on cell value to multiple tabs?

    oh, thanks a lot!
    Reply With QuoteRegister To Reply
  12. 08-17-2020, 03:58 PM #12
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,341

    Re: How to move rows based on cell value to multiple tabs?

    pleasure...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Move Rows to different Sheets based on Cell value(s) with Multiple Buttons
    By SeventySix in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2019, 04:25 PM
  2. [SOLVED] VBA Change Event, Move multiple rows based on drop down selection for multiple criteria
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-02-2017, 11:51 AM
  3. move rows to new sheet based on text and date in multiple sheets
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2014, 02:39 PM
  4. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  5. Urgent - dealing with multiple rows - copy "move rows" based on another reference column!!
    By eric_1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2013, 06:52 AM
  6. [SOLVED] Select rows based on date range and copy to multiple tabs
    By B-Rell in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-01-2012, 09:27 AM
  7. Move multiple rows from one spreadsheet to another based on certain criteria
    By pau.camp in forum Excel General
    Replies: 1
    Last Post: 04-05-2012, 07:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1