ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Preserving hyperlinks in linked cells (https://www.excelbanter.com/excel-discussion-misc-queries/14801-preserving-hyperlinks-linked-cells.html)

JulieW

Preserving hyperlinks in linked cells
 
I use the "paste link" feature to create custom sheets from data maintained
on a master sheet (in same spreadsheet). Some cells in the master sheet have
hyperlinks and I want these to show up on the custom sheets. But hyperlinks
are lost in the "paste sheet" process.

Is there a way to maintain linked cells that preserves the hyperlinks?

Thanks. --julie

Gary Brown

Is using the Hyperlink function viable?
HTH,
Gary Brown


"JulieW" wrote:

I use the "paste link" feature to create custom sheets from data maintained
on a master sheet (in same spreadsheet). Some cells in the master sheet have
hyperlinks and I want these to show up on the custom sheets. But hyperlinks
are lost in the "paste sheet" process.

Is there a way to maintain linked cells that preserves the hyperlinks?

Thanks. --julie



All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com