Excel formula with changing rows going in order

Solved
Jneerg Posts 1 Registration date Wednesday December 29, 2021 Status Member Last seen December 29, 2021 - Dec 29, 2021 at 11:34 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jan 3, 2022 at 11:29 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jan 3, 2022 at 11:29 AM
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
0