Hi there,
Looking at sheet 2 of the attached spreadsheet, I am looking for help writing a macro that will copy the formula pattern below:
=Sheet1!E3
=Sheet1!F3
=Sheet1!G3
=Sheet1!H3
=Sheet1!J3
=Sheet1!E4
=Sheet1!F4
=Sheet1!G4
=Sheet1!H4
=Sheet1!J4
=Sheet1!E5
=Sheet1!F5
=Sheet1!G5
=Sheet1!H5
=Sheet1!J5
Etc.....
It would start in cell C2 of sheet 2 on the attached wookbook and continue down until row 5000.
Thanks,
Jordan
Bookmarks