Dear All,

I have a 2 column spreadsheet. I want a third column to perform the task described below.

Col A contains the path and filename of my PDF file
Col B contains the page number within the PDF which I would like to present to me when I click on a wonderful solution in Column C.

The wonderful solution might be a variant on the =Hyperlink function. When I use Hyperlink as it is currently functions, regardless or not whether I append #page[23] , I cannot get the PDF to open at the correct page (23 in that example).

Any brains out there who can sort me out, much appreciated.

I have thousands of rows, and many of the PDF files have many tens of pages (one of them has nearly 2000 pages)

Thanks

Gerry.