Group Contents

Please Login or Register  to view this content.

I would like to add/adjust this macro so it can do this..


1. Go to Sheet “R1” look at the contents in cell A1 then look for a duplicate of those contents in Column C, Column E, Column G, Column I, Column K, Column M, Column P, and Column S.

2. When Column A has duplicates in
Column C
Column E
Column G
Column I
Column K
Column M
Column P
Column S

I would like to copy that row of..
Columns A plus Column B
Columns C plus Column D
Columns E plus Column F
Columns G plus Column H
Columns I plus Column J
Columns K plus Column L
Columns M plus Column N and Column O
Columns P plus Column Q and Column R
Columns S plus Column T and Column U

3. Then Go to Sheet Final paste those different rows into the same row, so
Column A:B
Column C:D
Column E:F
Column G:H
Column I:J
Column K:L
Column M:O
Column Q:R
Column T:U
Would all be in the same row

4. Go back to Sheet R1 and repeat this process for every cell in Column A

However, Columns M:O, Columns Q:R, and Columns T:U will have duplicates, when that happens I want to put those duplicates under their original occurrence while protecting the entire row

I attached an example of the data before and after, with a lot less rows. Thank you.