Dynamic Hyperlink Based on 2 x Cell value
I have looked about but can’t see anything quite like what I need.
I apologize if there is.
I need to create a automatic hyperlink based on the value of two cells.
A1= SMITH A2= ORDERNUMBER A3= HYPERLINK
The hyperlink in A3 will be MoreInfo\ORDERS\SMITH\922908
CELL A1 IS THE CUSTOMER NAME AND A2 IS THE ORDER NUMBER, THESE WOULD CHANGE FROM LINE TO LINE
I CREATE THESE FOLDERS IN A SHARED DRIVE (MoreInfo\ORDERS\??\922??
BEFORE I ENTER THE INFO ON THE SPREADSHEET.
So I JUST NEED THE LINK TO APPEAR IN A3 AS SOON AS I FILL IN THE CUSTOMER AND ORDER IN A1 AND A2
I hope this makes sense, I hope someone can help as I am tearing my hair out here.
Thanks in advance