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

1. ## 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

2. ## 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?

3. ## 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. ## Re: Move rows of data from one sheet to another based on specific values of sheet

I hope this helps explain my contortion.

5. ## 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. ## Re: Move rows of data from one sheet to another based on specific values of sheet

Here's a sample file. Thank you

7. ## 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. ## Re: Move rows of data from one sheet to another based on specific values of sheet

Thank you so much. Worked as advertised.

9. ## 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. ## 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

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