hi peoples,
my dilemma is i have a sheet with employees and there details, also column with links to there documentation i.e Photo of drivers license so a1 would be Joe blogs a2 would be link to joe's drivers license photo, what i want to do is have in sheet 2 something like sheet2.a2=sheet1.a2 and have sheet2.a2 a click-able link the only way i have been able to do this is to copy and paste or create a new link in sheet 2, any help would be greatly appreciated

cheers