Insert hyperlinks and bookmarks

Add the contract hyperlinks into the vendor master so procurement can access the originals. On sheet Vendors paste the two contract URLs next to Apex Supplies and Kiran Logistics in column G, and add a bookmark link to cell A1 of sheet Terms so legal can jump straight to the arbitration clause. Verify both links open for external users and send to Maya by Wednesday afternoon for sign-off.

Before I send the vendor master to procurement, make the hyperlinks obvious and the key anchor findable. Put visible 'Contract' text in column G with the external URL, and create a bookmark on sheet Terms anchored to cell A1 labeled 'Arbitration clause' with a short tooltip showing last review date. Flag any broken URLs and highlight vendors missing contracts so a reviewer can approve quickly.

I added a bookmark to the arbitration clause on sheet Terms, but procurement says the link jumps to the top of the sheet, not the clause, and now they distrust the whole vendor file. I cannot tell whether I mis-anchored the bookmark or if the sheet structure changed. What probably failed and what clear, immediate steps get procurement a reliable link before their review at 3pm?

Over several vendor lists we keep getting tickets: bookmarks go to the wrong place, external URLs are dead, and procurement loses trust in the master file. I want a standard that stops this churn. What operating habit should we enforce when adding contracts and bookmarks, who should own link verification, and what quick checklist prevents these recurring failures?