Formula is not dragging down properly

[rplohocky]

Hello,
I have a formula that links a cell from another WB. The formula works fine but when I drag it down the column in order to link other cells it doesn't copy correctly. It actually copies identical without adding the next row as a reference. I know by placing a "$" in front of either letter or number it will remain static but I dont have them and it still remains static.

=INDIRECT("'[Test 2018 Expences.xlsm]"&A$28&"'!$A3")

The A3 at the end is the issue. When you drag the formula down it remains A3. I need it to grow to A4, then A5 and so on.

Any Idea's?

 

[JoeMo]

Untested, but maybe:

=INDIRECT("'[Test 2018 Expences.xlsm]"&A$28&"'!$A"&ROW(A3))

 

[rplohocky]

Untested, but maybe:

=INDIRECT("'[Test 2018 Expences.xlsm]"&A$28&"'!$A"&ROW(A3))

JoeMo that works great going down!

I thought I would be able to drag it across as well but that doesn't work. Down the column is fine but dragging it across a few rows doesn't work.

Any way to modify it to work across columns as well???

Thanks for your help!

 

[rplohocky]

JoeMo that works great going down!

I thought I would be able to drag it across as well but that doesn't work. Down the column is fine but dragging it across a few rows doesn't work.

Any way to modify it to work across columns as well???

Thanks for your help!

JoeMo,
i believe I fixed my own problem. I switched out the second to the last "A" to a "B" on so on and that worked. I had to change each cell going across the row but there was only 12, then I was able to drag it down and it all worked fine. Thanks for your help again!