Hi,

I am a novice VBA programmer and would appreciate any help.

I need to set values for 2 different input cells (week and score) and then copy/paste the value for a 3rd cell (growth). Growth needs to be copy/pasted into a separate workbook. Then score needs to increase by 1 (with week constant) for a certain range of scores (say 0 to 100) and repeat the copy/paste. Once it has iterated through all the scores, then the week needs to increase by 1 and everything needs to be repeated.

So there are 2 loops that need to happen, with score loop nested inside the week loop. Each time the score increases, then paste location needs to move down 1 row. Each time the week increases, the paste location needs to move right 1 column.

Thank you!
Jan