Hi all, I've got an Excel workbook with two sheets...one named "Sheet1" and one named "formulas".
In Sheet1, cells A20 through A25 look like this:
=formulas!A2
=formulas!B2
=formulas!C2
=formulas!D2
=formulas!E2
=formulas!F2
I can't seem to find a way to tell Excel that I want to autofill cell A26 on down to look like this:
=formulas!A3
=formulas!B3
=formulas!C3
=formulas!D3
=formulas!E3
=formulas!F3
=formulas!A4
=formulas!B4
=formulas!C4
=formulas!D4
=formulas!E4
=formulas!F4
=formulas!A5
=formulas!B5
=formulas!C5
=formulas!D5
=formulas!E5
=formulas!F5
and so on.
Do any of you fine folks know how I could accomplish this? Thanks!
Bookmarks