Question around Hyperlinks

[counterscc]

Hello all! I have tried everything I can think of but still can't seem to come up with anything.

I run 2 reports daily....1 to pull all orders that shipped the previous day and 1 to pull the Carrier and tracking info for those same orders.

I merge the two together using a macro to clean it all up and to Vlookup the carrier and tracking info over to the master sheet.

I have a column (col M in this case) that has the Carrier Name. I would like to build it in a macro somehow to make those Carrier names hyperlinks so that I can click on the Carrier name on my sheet and it would direct me out to their website so that I can track the shipment.

We use approx 20 different carriers and each day they are all a little different. Any help would be greatly appreciated.

Thanks

 

[counterscc]

Just checking in to see if anyone could help me out with this one. Any guidance would be greatly appreciated. Thanks

 

[bensonsearch]

Just checking in to see if anyone could help me out with this one. Any guidance would be greatly appreciated. Thanks

Hi
where would the web address's be stored? if you had a file or another sheet with the number vs web address then can make a macro that runs at end of your other macro.

all would do is vlookup and return value as =HYPERLINK(blah blah)

 

[counterscc]

Thank you very much for your help! With a little messin' around I was able to get it to work just great! Thanks again

Hi
where would the web address's be stored? if you had a file or another sheet with the number vs web address then can make a macro that runs at end of your other macro.

all would do is vlookup and return value as =HYPERLINK(blah blah)

 

[bensonsearch]

Thank you very much for your help! With a little messin' around I was able to get it to work just great! Thanks again

glad i could help