Re: Loop Column A nested Loop column B, copy same values, skipping some matching valu
Updated with workbook and any further info I could think of.
Added two lines inside the If statement. First line of code is to show where I put it. It has not helped.
Code
rd.Cells(j, 1).Delete Shift:=xlUp ' delete number from sheet1 col A
i = i + 1 ' force the loop to run the previous cell in column B again
j = j + 1 ' force the loop to run the previous cell in column A again
Thought maybe it was skipping cells due to the delete, so I forced it to re check the "new" cell that had moved up instead of moving up a cell immediately... obviously didn't help, but I'm getting a little desperate.