insert hyperlinks

[PIsabel]

Hello.
I have a budget sheet that has a macro that creates a copy of that budget and inserts the data (budget number, customer name, and date) into a listing.
I am trying to create a code that when entering this data in the listing the code create a hyperlink in the number of the budget so that I can open that file by clicking on its number.
Someone help me?

Isabel

 

[NMa91]

Use following but change according to your sheet references:

Range("A1").Hyperlinks.Add Address:="", TextToDisplay:=brange.Value, Anchor:=brange, SubAddress:="Sheet1!A1"