I am trying to setup a dynamically linked cell.
This is the link i have:
='https://mezcom.sharepoint.com/sites/Mez/Shared Documents/John Smith/[John Smith 2018 Time Sheet.xlsx]Jan 1-15'!$AH$8
this is what i am trying to do:
B1 would equal a persons name, b3 would be the year...