Loop thru column, copy value to different sheet based on value

[cpyter]

Hello,

I am stuck.. I am trying to create a macro which will look at column C in Sheet1 whose length is dynamic, and copy the value to the right of it into another sheet where the value in column C matches. As an example, my hope is to loop through the Aisle column (column C) and paste the error (Column D) into Sheet2, where there is a full list of aisles which is matched from Sheet1.


Aisle Error
2 1
4 2
7 0
8 2
12 1

Any guidance would be genuinely appreciated.

[mo4391]

Does it have to be a macro? It sounds like this can be accomplished with a vlookup or index/match formula.