+ Reply to Thread
Results 1 to 10 of 10

Move rows of data from one sheet to another based on specific values of sheet

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Guam
    MS-Off Ver
    2010
    Posts
    30

    Move rows of data from one sheet to another based on specific values of sheet

    I need a macro which moves data from one sheet to another sheet based on specific values of a sheet.

    Data (sheet 1)
    1___2___3___4___5
    7___9___3___3___6
    9___9___3___2___5

    Inputs (sheet 2)
    1___4
    9___3
    9___5

    Output (sheet 3)
    1___2___3___4
    9___3
    9___9___3___2___5
    Attached Files Attached Files
    Last edited by buntalan80; 02-26-2013 at 12:54 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Move rows of data from one sheet to another based on specific values of sheet

    Unable to understand the logic can you please give a brief about it?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    05-15-2012
    Location
    Guam
    MS-Off Ver
    2010
    Posts
    30

    Re: Move rows of data from one sheet to another based on specific values of sheet

    On the inputs sheet, there are two values. Those two values, are the same values found on the data sheet. If you look at the example, on the inputs sheet for the first row the two values are 1 and 4. On the data sheet for row 1, data(1,1) has a value of 1 and data(1,4) has a value of 4. I need the macro to move all of the data from data(1,1) through data(1,4).

  4. #4
    Registered User
    Join Date
    05-15-2012
    Location
    Guam
    MS-Off Ver
    2010
    Posts
    30

    Re: Move rows of data from one sheet to another based on specific values of sheet

    I hope this helps explain my contortion.

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Move rows of data from one sheet to another based on specific values of sheet

    Thanks for the brief and before writing the macro please attach a sample workbook for understanding the data structure and cell references.

  6. #6
    Registered User
    Join Date
    05-15-2012
    Location
    Guam
    MS-Off Ver
    2010
    Posts
    30

    Re: Move rows of data from one sheet to another based on specific values of sheet

    Here's a sample file. Thank you
    Attached Files Attached Files

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Move rows of data from one sheet to another based on specific values of sheet

    Try this code...

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    05-15-2012
    Location
    Guam
    MS-Off Ver
    2010
    Posts
    30

    Re: Move rows of data from one sheet to another based on specific values of sheet

    Thank you so much. Worked as advertised.

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Move rows of data from one sheet to another based on specific values of sheet

    Glad it helps you and thanks for the feedback

  10. #10
    Registered User
    Join Date
    05-15-2012
    Location
    Guam
    MS-Off Ver
    2010
    Posts
    30

    Re: Move rows of data from one sheet to another based on specific values of sheet

    You deserve the positive feedback and you earned every bit of it!!! Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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