I have created a formula to reference a cell in another workbook. I now want
to copy the formula down a number of consecutive rows, but I want it to
reference the cell in every second row in the other workbook.

How can I do that?