Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
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.
The final code for example would be
The
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.
Excel Formula:
P:\ File Structure\Shared Documents\(FOUO) Special Handling\(FOUO) Inbound\2.FLIGHT MANIFEST\
The final code for example would be
Excel Formula:
P:\ File Structure\Shared Documents\(FOUO) Special Handling\(FOUO) Inbound\2.FLIGHT MANIFEST\2021\04 APRIL\BAH1C00956.pdf
The
Excel Formula:
2021\04 APRIL\
Thank you very much indeed.