Auto Fill Cell (Drag formula) to fill by odd numbers

[sdoppke]

Hi everyone, this is probable painfully obvious but i cant find anything that referneces this exactly. I have a formula: ='Schedule at a Glance'!B231 and need the rows to autofill by odd numbers, so the next one down would be ='Schedule at a Glance'!B233 and so on. Can anyone help with that?

Thanks everyone

sd

 

[njimack]

=INDIRECT(ADDRESS(229+ROW(A1)*2,2,,,"Schedule at a Glance"))

 

[sdoppke]

=INDIRECT(ADDRESS(229+ROW(A1)*2,2,,,"Schedule at a Glance"))

Rock Star!!!

 

[Scott Huish]

=INDEX('Schedule at a Glance'!B:B,230+(ROWS($A$1:A1)*2)-1)