For Each Loops and copying cells next to c.Value

Hi all, first I'll submit my code and then the problem.

Please Login or Register  to view this content.

The logic behind this is supposed to be:

1. For each value in one worksheet (LookTbl), find the corresponding value in another worksheet (IndMthly (2)).
2. When found, copy the values in the range from LookTble and paste them into their proper cells in IndMthly (2).

The first iteration happens successfully. However, when the second iteration occurs, the range to copy goes back to the first iteration's data range.

How do I select the cells for Next c when it stays on the first c's row. Sorry if this is confusing but I am confused. If more is needed please let me know.

Thanks

Post an example workbook demonstrating BEFORE/AFTER so we can see what the macro is supposed to accomplish.
Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.