Another way to create the links is to enter this formula in D1 and copy it to the end of the list. The workbook name is ard coded so you will have to alter that to the real name.
=HYPERLINK("[Grade(1) (1).xls]" & C40 & "!A1",C40)
Another way to create the links is to enter this formula in D1 and copy it to the end of the list. The workbook name is ard coded so you will have to alter that to the real name.
=HYPERLINK("[Grade(1) (1).xls]" & C40 & "!A1",C40)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks