chunone3853
New Member
- Joined
- Mar 4, 2023
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
I have a formula that references D9, G9, J9, K9 and M9
Over time that will change to D10, G10, J10, K10, and M10
Then 11. Then 12. Etc This change occurs every five days, and I'd rather update one cell, that five cells each with a complicated formula.
Is there a way to have the "9" portion of the address reference another cells value, so I only need to update that one cell?
Over time that will change to D10, G10, J10, K10, and M10
Then 11. Then 12. Etc This change occurs every five days, and I'd rather update one cell, that five cells each with a complicated formula.
Is there a way to have the "9" portion of the address reference another cells value, so I only need to update that one cell?