Morning all,

I'm trying to Goal seek a % dependent upon a copy and past of other cells...

that's probably not going to make sense so please see attached.

I have created a macro to copy and paste the values, however once they are copy and pasted I then need to run goal seek so that cell B8=B12 and then copy paste etc etc...

Is there a continuous loop I can run that copy pastes then runs goal seek until B8=B12??

Many thanks in advance.Test1.xlsm