create a link base on cell value
Good day, i was trying to create a link for every single folder depending on the code indicated on A column. is there any way i can do it easily instead of manually putting the path (located on E column)? the Name (A column) can go up to WRK-1-23 up to WRK-200-23 and it takes a lot of time to do it manually.
Hope anyone could help. thank you.
If you have a list of folders in column A, and the correct links in column E, then try in cell 'B2';
then pull down.Formula:
Please Login or Register to view this content.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
Please empty all expected results and try:Formula:Please Login or Register to view this content.
Hi, what i mean is for example the Path (E column) is where the folder is and i want to put the link in B Column.
Thank you.
Is than not what post #2 is doing? Getting the path from column E and showing it as link in column B ?Originally Posted by Luigem
Hi,
The path column is just an example of my directory. It is not encoded to the excel file.
i have a main folder which is
C"\Users\Gemille\Desktop\Gem - Maintenance\Trouble Work Request 2023\K - PHRMO
the next path is the name in the column A (w/c are WRK-1-23, WRK-2-23 ...)
will it be possible to add
this directory
C:\Users\Gemille\Desktop\Gem - Maintenance\Trouble Work Request 2023\K - PHRMO PLUS the Name indicated to Name Column?
I'm sorry if this isn't clear hehe.
thank you.
If you don't have the folder path in column 'E', and the main folder is always the same, you can set that in the formula.
In cell 'B2' try, then pull down;
Formula:Please Login or Register to view this content.
Blue = Your main directory
Red = The final folder name from column 'A'
Green = What is displayed in the cell (friendly name)
If you don't want the 'friendly name', then use in cell 'B2', then pull down;
Formula:Please Login or Register to view this content.
.
Last edited by ORoos; 12-20-2023 at 05:15 AM. Reason: Added screensot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks