I know I've done this before, but I just can't seem to get it right.
Sheet 1, Col B contains text. I want to hyperlink to the identical text in sheet3, Col A if it exists.
The sheets are named if that makes a difference.
Thanks
I know I've done this before, but I just can't seem to get it right.
Sheet 1, Col B contains text. I want to hyperlink to the identical text in sheet3, Col A if it exists.
The sheets are named if that makes a difference.
Thanks
It means you want a macro to prepare hyperlink in Sheet1 column B in connection with Sheet3 column A ??
- Battle without fear gives no glory - Just try
Yes, I should have been more clear. I want a macro to create the hyperlinks which I can run anytime I add more data.
Thanks
See next code
Please Login or Register to view this content.
Almost got it. The Sheet names are "MAIN" and "RECIPIENTS"
I don't know what is causing the compile error.
compile error.jpg
It is very simple .. restart from the original code and adjust constants to your need
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by PCI; 01-06-2018 at 05:49 PM.
That did it, thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks