Macro To Copy Paste Value Until A Condition Is Met

limwilliam Posts 1 Registration date Sunday May 22, 2016 Status Member Last seen May 22, 2016 - May 22, 2016 at 10:06 PM
Hello All

I could sure use some help on a Macro, i'm still a newbie

The Case is :

A1 is the sum of row 4

In A3 there is a value of 1, B3 there is a value of 1, and so on

I need a macro to copy paste value from a3 to a4, then from b3 to b4, c3 to c4, and so on but it will stop copying if a1 is equals 10

Please can anyaone help me ?

Thank you very much for your precious time