danrofohio
New Member
- Joined
- Mar 14, 2012
- Messages
- 4
I have a spreadsheet where the basic function is to merge information from two worksheets. One sheet has a column hyperlinks (to external web pages) and a unique date for each row. The other sheet has descriptive information, tags, etc. I now have all the data merged, sorted, and formatted the way I want on a third sheet. Now, I want to eliminate the first two sheets, because I don't need them, and I want to save the third sheet as a one-tab, html file.
Normally, I would just copy all of the cells on the third sheet and paste them to the same location using paste special - values and formats or just values. However, when I do that, I lose all the hyperlinks. One column looks like this:
I need to get rid of the formulas while still retaining the functionality of hyperlink. If I copy and paste special (values) it still looks like a hyper link with the correct URL, but the hyperlinks to the web pages don't work any more.
How can I either:
A.) Copy/paste the values while retaining the hyperlink functionality, or
B.) Convert the values to hyperlinks again?
Thanks,
Dan R.
Normally, I would just copy all of the cells on the third sheet and paste them to the same location using paste special - values and formats or just values. However, when I do that, I lose all the hyperlinks. One column looks like this:
=HYPERLINK(VLOOKUP(A3,StudyLinkTable,4,FALSE))
I need to get rid of the formulas while still retaining the functionality of hyperlink. If I copy and paste special (values) it still looks like a hyper link with the correct URL, but the hyperlinks to the web pages don't work any more.
How can I either:
A.) Copy/paste the values while retaining the hyperlink functionality, or
B.) Convert the values to hyperlinks again?
Thanks,
Dan R.