Previous Topic Next Topic

Excel formula with changing rows going in order

Solved/Closed
Jneerg Posts 1 Registration date Wednesday 29 December 2021 Status Member Last seen 29 December 2021 - 29 Dec 2021 à 11:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 Jan 2022 à 11:29
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
3 Jan 2022 à 11:29
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses