I am trying to reference cells in Column A of Sheet "Job Summary” from Sheet “Report”.
Except I need to allow 15 empty rows between each referencing formula on “Report” (16 rows total including the row with the formula).
So, dragging down the formula does not work. I thought I could create a filter to hide the 15 rows in the middle, then copy down, but that copies the formula to the hidden rows as well.
The 500 cells to be referenced are in order on “Job Summary” in a column A3:A502..
Need to copy this down 8,000 rows on “Report” so really need a solution.
The first formula should be entered in cell A4 on “Report” referencing Cell A3 on “Job Summary”.
Cell A4 on “Report” ='Job Summary'!A3 Cell A20 on “Report” =’Job Summary!A4 Cell A36 on “Report” =’Job Summary!A5
And so on…
Need a solution to copy down this formula on “Report”.