Looking for advice on how to deal with PDF doc

[bjjc51192]

So I have an excel sheet that has 56 tables. I created a reference table, that has the name of the sheet in one column, and the page number the data was collected from in another column.

I want to make it more dynamic and allow the user to click on the cell where the page number is and it take them to the respective pdf page. I thought of doing this with hyperlinks, however since this is a file that will be sent to multiple users, i'm afraid the hyperlink would crash since I store the pdf locally.

I also looked into embed the pdf in the sheet, but could't find much out there on how to open the embeded pdf to a specific location.

Thoughts?

 

[sijpie]

Here is one way of doing this:
https://stackoverflow.com/questions/44362127/open-embedded-pdf-to-a-certain-page

Else the easiest way is to bundle the pdf's and excel sheet together in one directory (or pdf's in subdir) and make the hyperlinks. Then zip the lot and send to the users as zipfile.

alternative would be to embed each page of the pdfs as imagee or pdf. But this will most likely be massive undertaking