Skip and copy formulas

[mahadevan.swamy]

Hi,

I have two workbooks (input and output) where one workbook(output) is
linked to the other. Now i want to copy formulas from the output
workbook to a new workbook and the formulas remain the same staying
linked to the input workbook. Now i want to drag down formulas from
one cell horizontally and in this formula, it should skip 5 columns in
the input workbook and calculate automatically. Is there any way to do
this? Thanks in advance

 

[David Biddulph]

You could try something like =OFFSET(Sheet2!$A1,0,5*(COLUMN()-1))