Hello,
I am working on a code generator where I have x rows of data where row 1-2 only has a formula in column A, Row 2 has Text in Column B only, rows 3-10 (for example has formulas in Column C. I have to copy or fill down these x lines of code 80 times but I am not finding a way to index the cell/sheet references once per instance since I'm copying many rows at a time. Attached image is showing formulas as an example. Second image is format of reference cells on the sheet 3. Looking for a way to copy or fill these down so the cell reference in the second set all point to row 3. Third set to row 4 and so on.
Please ignore the fact that the formulas in column C are all the same, my real formulas are different but this should illustrate my issue.
I am working on a code generator where I have x rows of data where row 1-2 only has a formula in column A, Row 2 has Text in Column B only, rows 3-10 (for example has formulas in Column C. I have to copy or fill down these x lines of code 80 times but I am not finding a way to index the cell/sheet references once per instance since I'm copying many rows at a time. Attached image is showing formulas as an example. Second image is format of reference cells on the sheet 3. Looking for a way to copy or fill these down so the cell reference in the second set all point to row 3. Third set to row 4 and so on.
Please ignore the fact that the formulas in column C are all the same, my real formulas are different but this should illustrate my issue.