I attached a workbook to this post to give you a clearer idea of what I am trying to accomplish. More specifically If you look at sheet ‘Matched’ you may better understand the end result I am going for. I also included a code at the bottom of this post.
I am thinking the procedure I am describing here would produce sheet ‘Matched’ in the attachment but if you can think of a better way I am all ears.
Copy Column A:B from sheet ‘Original’ to sheet ‘Matched.’ Compare contents in Column A sheet ‘Matched’ with contents in Column C sheet ‘Original’ when matching contents are found in sheet ‘Original’ cut that row of C:E and paste it into sheet ‘Matched’ the same row as its match but in Column C:E. After all the matching contents from Column C have been found, cut the remaining contents of Column C:E sheet ‘Original’ and paste them into Column C:E sheet ‘Interim’. In sheet ‘Interim’ delete the empty rows between data in Column C. Once all the empty rows have been deleted cut the rows with data from Column C:E sheet ‘Interim’ and paste them into sheet ‘Matched. I would like to paste the data into the first available rows in Column C:E that do not have data in Column A. Next I would like to repeat the same process for Columns F:G, Columns H:I, Columns J:K, Columns L:M, Columns N:O, and Columns P:R, checking Column F, Column H, Column J, Column L, Column N, and Column P for matching contents in Column A. The only difference would occur when remaining data was pasted from sheet ‘Interim’ to sheet ‘Matched’. For example with Column F instead of pasting the data into the first available rows in Column F:G that do not have data in Column A, I would like to paste Column F:G into the first available rows in Column F:G without data in Column C. Likewise for Column H:I, I would like to paste Column H:I into the first available rows in Column H:I without data in Column F. This may sound confusing but if you look at the attachment what I am describing will be much clearer.
Here is the code I have now; thank you for previous help JB. The code does everything I am trying to do; the only difference is the code copies and pastes instead of cutting and pasting. Also, the most important part and the reason for this post, the code does not carry over leftover data without matching records in Column A from sheet ‘Original’ to sheet ‘Matched’. Can you help me with this step? Below is the code I am using; thank you in advance for your help!
Bookmarks