i have a document control log where i have first column comprised on submittal numbers , by using the same submittal numbers i have created all folders in share drive and paste relevant files there,
i use to create hyper link on 1st column manually because link location does not change by scrolling it down to more rows.
i need your support if there is any way by use of vba that use the submittal name as link on 1st column with the same location from share drive.
farhanleos
Greetings SIr,
i need your support on below subject
i have a document control log where i have first column comprised on submittal numbers , by using the same submittal numbers i have created all folders in share drive and paste relevant files there,
i use to create hyper link on 1st column manually because link location does not change by scrolling it down to more rows.
i need your support if there is any way by use of vba that use the submittal name as link on 1st column with the same location from share drive.
i hope you will help me out