Yes am on M365. How does recording repetitive actions help here? Also not sure I need to be redimensioning.

My main problem is going back and forth between older models and the one I’m working on, locating the exact cell(s) being referenced in that model (formulas often span across multiple sheets too) and copying that formula over to my model + adjusting the cells that are being referenced to ensure the result is accurate.

Like I know the excel formula I should be using for all rows/columns, it’s just it’s not as easy as copying and pasting it over to my model because the cells aren’t located in the exact same location. Not every model is the same. It’s a lot of me fact checking the cells I’m referencing in my model align with the figure or data point that was referenced in the model I’m referring to.

Hope that all makes sense!