Excel formula with changing rows going in order

Solved/Closed
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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