Hello,
I've looked for code already posted but am not finding what I need exactly. I'm not that good with VBA so I hope someone can post some code I an run with.
I have sheets in a workbook:
Sheet1 has a range of values in column 1 (I.E. A1 through A1000).
Sheet2 has 1000s of rows of data (I.E. A1 through XX3000). Most, but not all, of the values in the range of Sheet1 will be found in column G in Sheet2.
Sheet3 is empty.
I am looking to:
I've looked for code already posted but am not finding what I need exactly. I'm not that good with VBA so I hope someone can post some code I an run with.
I have sheets in a workbook:
Sheet1 has a range of values in column 1 (I.E. A1 through A1000).
Sheet2 has 1000s of rows of data (I.E. A1 through XX3000). Most, but not all, of the values in the range of Sheet1 will be found in column G in Sheet2.
Sheet3 is empty.
I am looking to:
- Get value from A1, sheet1.
- Find match of that value in column G of sheet2.
- Copy the entire row where the match is found in sheet2 to row 1, sheet 3.
- Repeat above for the range of values in Sheet1 (copying to the next incremented row in Sheet3) for each repetition.
- If no match is found, create a new incremented row on Sheet3 anyway and place the value from Sheet1 in the column G cell.