Tracing Formula Frustrations — due to complex cell referencing​

If you wanna replace A6 with another cell, the a ctrl+H(replace can work). Also, you could create named ranges to be used in the formula.

Not sure what you are trying to do here, can you try explaining again?

If you have to update/change formulas on a regular basis, perhaps the formulas were not properly structured in the 1st place?

Are you asking for help with (dynamic) named ranges?
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version only your OS ( Vista)
Thanks