Kiloelectronvolt
Board Regular
- Joined
- Oct 5, 2015
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi All!
This is hard for me to explain, but is there a way to hyperlink a cell to a specific file only using a prefix of the filename?
All of our files start with PO 100-, PO 101-, PO 102- but then there's random employee descriptions typed after the prefix.
If the PO # is listed in B2, Can you hyper link to C:/Filepath/&B2 and have it pull the file with that prefix in it
Example:
So, if it's C:/Filepath/PO 101-Staples for office.pdf Can excel hyperlink to the file based of the "C:/Filepath/PO 101-"
This is hard for me to explain, but is there a way to hyperlink a cell to a specific file only using a prefix of the filename?
All of our files start with PO 100-, PO 101-, PO 102- but then there's random employee descriptions typed after the prefix.
If the PO # is listed in B2, Can you hyper link to C:/Filepath/&B2 and have it pull the file with that prefix in it
Example:
So, if it's C:/Filepath/PO 101-Staples for office.pdf Can excel hyperlink to the file based of the "C:/Filepath/PO 101-"