Excel formula with changing rows going in order

Solved
Report
Posts
1
Registration date
Wednesday December 29, 2021
Status
Member
Last seen
December 29, 2021
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
I am mapping one cell to another spreadsheet and I trying to figure out how to change the row without having to manually change each line. For example: ='S:\Folder\[File.xlsm]Month'!$D$4 Next would be E4. Thank you for your help

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Jneerg,

The dollar symbols in your formula is what makes the cell reference the same when dragging. Remove them and the formula's cell reference will change when dragging.

Best regards,
Trowa