Macro to loop and copy

[tsakta13ole]

Hi. I'm attaching my workbook. I'm looking for a macro that does the following: In sheet2 , F2 to take values from 336 to 369.6 every 2% and each time it takes a value to copy B11 of sheet2 to sheet3 at cell A4.
For example, put 336 to F2 and B11 becomes 6827. Copy to A4 of sheet3 6827.
Then, put 342.72 (336*1.02) to F2 and B11 becomes 7129. Copy to A5 of sheet3 7129.

Thanks for any help!

P.S: I have already posted this problem in another forum http://www.mrexcel.com/forum/excel-q...ml#post4461424

[StephenR]

Try this:

Please Login or Register  to view this content.

[tsakta13ole]

This works! Thanks!