For each non-empty cell.

Hi All,

I realized that I did a poor job describing my problem so I'm adding the sample file to illustrate what I'm trying to do.

I want to take the data from Stage 1 on Sheet1, Range D5:D9, copy it to the target location on Sheet2, Range C5:C9, perform the calculations, and copy the results, Range E5:E9 back to Stage 1 on Sheet1 in the Output section, Range D15:D19.

Then I want to go to Stage 2 and repeat this process. At the first empty cell, K5, I want the macro to recognize that the cell is empty and quit the loop.

This is a very simplistic example of a MUCH larger set of calculations.

I haven't written many loops, and the few that I have used have come from some very generous individuals on this forum. I'm really struggling to get better at writing loops so any help would be GREATLY appreciated. Thanks much.

Best regards,

-gshock