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
Bookmarks