Hey there.
I wrote a thread a week ago regarding linking to a specific cell in another workbook. Since my files were stored in a file management program called CIDM, I had to ask people who knew something about CIDM. I did and the solution wasn't complicated at all, and I think it was similar to doing it when you are dealing with a normal hyperlink. It required clicking on the specific cell you wanted your link to be linked to, and typing ''='' in the function, then moving to the hyperlink itself and selecting it. Which I did. The formula in the cell then looked like this:
It didn't work! So I tried doing it the other way around and going in the hyperlink adress to change it, based on the adress that appeared above, which included the specific cell adress.=PwDMoniker.PwDMoniker.1|'PCDOCS://NCR/2305496/R'!'!Contributions!R28C21'
The hyperlink, before my changes, omitted the bold part, which is the specific worksheet and cell.PCDOCS://NCR/2390132/R'!'!Federal%20Interlocutor!R1C2'
But that too didn't work.
Now, the person who helped me isn't in today, or not yet, so I was asking if one of you guys knew a way similar to the one she showed me to create hyperlinks to specific cells in a worksheet.
I'm sorry if this is hard to understand, I'm french.
But thanks for reading and trying to help,
Charles
Bookmarks