Editing Multiple Hyperlinks

[sjcuk]

I have an document where one tab (Tab A) contains a multiple number of hyperlinks which link to individual cells on another tab (Tab B). I wish to add in another column on Tab B but this will affect the pathways for the existing hyperlinks. Is there a way around this? I basically wish to bulk edit hyperlinks to move them all one column across.

[tim201110]

https://search.yahoo.com/search;_ylt...s%20in%20excel

[sjcuk]

Thanks, but I was hoping for a specific answer to my question. I have already done a general search of editing multiple hyperlinks but couldn't easily see solution to my issue.

[tim201110]

specific? there is no any mentalist here.