Automatically add to link after entry in a column.

[Livin404]

Greetings, We're adding to a database, and within a Column (H) I would like to be able to type in a word than after hitting entering or tab key it will automatically add the link. I believe all or nearly all will be saved in a PDF format. This is the portion of link that will never change.

P:\ File Structure\Shared Documents\(FOUO) Special Handling\(FOUO) Inbound\2.FLIGHT MANIFEST\

The final code for example would be

P:\ File Structure\Shared Documents\(FOUO) Special Handling\(FOUO) Inbound\2.FLIGHT MANIFEST\2021\04 APRIL\BAH1C00956.pdf

The

2021\04 APRIL\

portion I hope can be coded based the date in Column A. The 04 is not the day but a number to ensure the month folders are kept in order. The only thing that will be unique is the name BAH1C00956. So after typing in the name after the month a link is created after I come up with the name for the file. I would also have to ensure .PDF is inserted right after the last key entry in Column H.

Thank you very much indeed.

 

[Misca]

Not 100 % sure I understood what you're really asking for but the year & month part of the path is quite easy to achieve with a normal worksheet function:

=SUBSTITUTE(TEXT(A2,"YYYY/MM MMMM/"),"/","\")

The TEXT function takes the date from A2 and turns it into something like "2021/04 April/" and the SUBSTITUTE changes the forward slashes into backward slashes.

Once you have your full path you can turn that into a link with the HYPERLINK function.