OMG NoRisk.
If I knew what you were talking about I figure I would have this situation sorted and not have had a Question to ask.

I do know how to record a Macro and then go ahead and cut and paste and select Sheets and stuff like that.
And then stop recording and then perhaps modify the Macro to do it precisely what I want.

The one item that I don't know how to put in a macro unless I edit is the For x= 1 to 100 type.I use this a lot.

But I have never tried doing Formulas , but I will try and see if the Formula is in the Recorded Macro after I type it in a cell whilst recording .



EDIT:
Just reread what you Posted
Made perfect sense this time.
I'll give that one a try.

Thanks buddy.