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 hard 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 hard coded so you will have to alter that to the real name.
=HYPERLINK("[Grade(1) (1).xls]" & C40 & "!A1",C40)
Last edited by moreeg; 04-21-2012 at 06:40 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks