Hi all,
I have a simple question but I can't seem to find a solution to it. I have this formula in one of my cells =HYPERLINK("\\networkdrive\123\ABCD\Batch\WER\Export\"&C53&"\WER Batch"). Cell C53 consists of a date that changes everyday. However, when I click on the link it only takes me till folder "Export". Essentially, when I click on the link it should open "WER Batch" folder. Any help would be appreciated!
I have a simple question but I can't seem to find a solution to it. I have this formula in one of my cells =HYPERLINK("\\networkdrive\123\ABCD\Batch\WER\Export\"&C53&"\WER Batch"). Cell C53 consists of a date that changes everyday. However, when I click on the link it only takes me till folder "Export". Essentially, when I click on the link it should open "WER Batch" folder. Any help would be appreciated!