Hello Excel Gurus,
To start off I am learning macro as I go. But here goes to what I am trying to do for this macro. I have a tab lets say "Sheet1" where there is two columns of data A:B. Column B has hyperlinks to PDF's. Then I have "Sheet2" where I have cell B2 where someone can enter in a...