Shaolin
04-28-2005, 08:14 PM
maybe some of you like logic, well here is an ideal one
let's say there is spreadsheet A, B and C.
A contains a column full of links
A is linked to B, then the function hyperlink is written in prior to every address
i.e. - =HYPERLINK(file-worksheet-cell address)
B is copied onto C. (by going to the paste special and selecting values)
---
Is there a way so that this logical format can work as follows?
A contains a column full of links
A is linked to B and link is maintained in B
B is copied onto C (by going to the paste special and selecting values), but the link is maintained.
I don't want to type in HYPERLINK in the function bar.
Am i making any sense? i can reiterate if needed!
let's say there is spreadsheet A, B and C.
A contains a column full of links
A is linked to B, then the function hyperlink is written in prior to every address
i.e. - =HYPERLINK(file-worksheet-cell address)
B is copied onto C. (by going to the paste special and selecting values)
---
Is there a way so that this logical format can work as follows?
A contains a column full of links
A is linked to B and link is maintained in B
B is copied onto C (by going to the paste special and selecting values), but the link is maintained.
I don't want to type in HYPERLINK in the function bar.
Am i making any sense? i can reiterate if needed!