Copy formula

[inferes]

Hello,

I have in one cell: A1='companyA'!C11. This cell refer to character. I want to copy this formula down using mouse, but C11 should change by number 63, it should be someting like this:

A1='companyA'!C11
A2='companyA'!C74
A3='companyA'!C137
A4='companyA'!C200
etc.

By default excel change value by 1. Can you help me ?

[benishiryo]

hi inferes, welcome to the forum. try this in A1:
=INDEX(CompanyA!A:A,63*(ROWS(A$1:A1)-1)+11)

drag down the formula

Edit: should be column C:
=INDEX(CompanyA!C:C,63*(ROWS(A$1:A1)-1)+11)

[Pepe Le Mokko]

Starting in A1 =index('companyA'!$C$1:$C$5000,((row()-1)*63+11))

( adapt the range to your needs)

[inferes]

THX, everthing is ok, but I dont now, why I had to change comma to semicolon after $C$5000, because with comma excel showed a mistake.

[Pepe Le Mokko]

It's due to your regional settings, good that you spotted it, and bad for me not seeing it