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

Excel formula with changing rows going in order
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
How to change author in excel - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers

1 response

Answer 1 / 1

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

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!