Trying to copy a formula across 13 columns that have a blank column between each - so 26 columns in total. The formula gets data from another spreadsheet. At the moment I am going to each cell and copying the formula in and modifying the reference cell. Is there any way to make this quicker. I have tried dragging and copying when I have had 2 formulas filled in correctly however that does not work.

It wouldn't be so bad but it involves about 8 or 9 of these rows.

Thanks for any help