Hyperlinks and Laziness

[RaviWildcat]

Hi Everyone - I've got about 300 cells that need hyperlinks added

The cells all have the same format - The value is PI-XXXX and the hyperlink is https:\\I-am-lazy\PI-XXXX

In a perfect world I'd simply create a helper column using the hyperlink function, but I"ve been specifically instructed not to include functions in the final report (it feels like my hands are tied!)

I can use the hyperlink function to create the actual links, but when I copy and paste the values - the hyperlinks don't get copied as well


I'm lazy and I really don't want to double click on each cell, edit hyperlinks, add the hyperlink and then save, then repeat 300 times

Any suggestions?

Thanks,
Ravi

 

[oldbrewer]

so use a macro to run thru 300 cells and do the work

you are not lazy - you are smart