Kenneth Hobson Super old

  • Member since Nov 1st 2005
  • Last Activity:
Posts
1,825
Likes Received
5
Points
9,137
Profile Hits
1,274
  • 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

  • I had so much extra time thanks to your awesome code that I joined this forum just to tell you how awesome you are. Thanks!