Create Hyperlink text in column A, in a different workbook from VBA code that will reference a .pdf

[JeremyA1976]

Hi All,
I haven't received any replies on the past few posts, so maybe I am asking for too much, but I would think this request is a bit easier.

I have a button on my main sheet that I would like to do the following:
*The VBA code will be in the "Charge Out Log" workbook, "CHARGE OUT FORM" sheet, because this is where the information is computed.

1.) Write to column A of "Change Out Log" workbook, [CHARGE OUT LOG] sheet. I start at 120000 for the reference number and fill down another 15,0000 in a series to create our "Charge Out Number"
2.) I already have a formula that looks up the first blank space in column B and reports what the reference number is, which is NOT hyperlinked.
3.) When the code writes (or replaces) that reference number in column A, I want it to hyperlink to the .PDF it creates in a specific folder "Processed Charge Outs" which has the same name as the reference number.

I am very sorry if I am not being clear. If I can answer any questions about the details i am missing, i will do so. I have not started the VBA code yet because I am not sure where to begin in the process.

Thanks in advance