Auto Filling formula to change columns

[Luc1fer1022]

Hello,
I am working in Excel 2010. I want to auto fill my formula by dragging in down the column but I would like the row inside the formula to change.
So this is what I would like it to look like

A2- ='Education Data'!P2
B2- ='Education Data'!Q2
C2- ='Education Data'!R2

When I drag my formula down the column it changes the cell number and keeps the row constant.
Is there a way to do this?

thank you!

 

[Joe4]

If you are dragging it down the column, it wouldn't be A2, B2, C2 but rather A2, A3, A4.
Is that what you mean?

If so, try putting this in cell A2 and copying down:

=OFFSET('Education Data'!$P$2,0,ROW()-2)