autifill

[books4cars]

I want to apply this formula to a range of cells in a column:
='WEEK B'!R$192

I want the cells below to be 193, 194 etc. But they all fill with 92.

What do I do?

 

[VoG]

Remove the $

='WEEK B'!R192

 

[books4cars]

Got it. Just out of curiosity, whats is the intended pupose of the $ in this case?
Thx

 

[VoG]

$ makes a reference absolute. See http://www.cpearson.com/excel/relative.aspx