Excel Macros & Hyperlink Fixes

I have two Excel workbooks that need quick, precise VBA work.

In the first workbook you’ll revisit the hyperlink-editing macro you built for me earlier. It currently stops short of the new data I added; I’ll give you the exact row numbers that now have to be included, so the routine simply has to loop through those additional rows and perform the same Edit Hyperlinks action.

While you’re in that file I also need three small, self-contained macros:

• one that rewrites existing formulas so every sheet name reference updates automatically to the sheet the formula lives on,
• a second that does the same on another sheet, and
• a third that also pulls a single value from the sheet immediately before it and inserts that value into the current formula.
- a fourth that edits formulas in specific cells

The second workbook only needs the last type of macro—updating formulas so they bring in a value from the prior sheet.

Everything must be written in clean, well-commented VBA for the desktop version of Excel. When I run each macro, hyperlinks should update for the specified rows, formulas must point to the current sheet (no hard-coded names) or incorporate the value from the previous sheet exactly as described, and no unintended references should remain. A short implementation note explaining where to paste the code will finish the job.