|
He's talking about a cell like this:
=HYPERLINK("http://www.google.com","bigSearchEngine")
It would be easier if his data was like:
-+---------A------------------------ B-------------------------C
1| =HYPERLINK($B$1,$C$1) | "http://www.google.com" | "bigSearchEngine"
In fact, it would be trivial...his desired reference would be =B1. As it is, I'd be tempted to export the
formulas from column to a flat file and massage them with a text editor.
Gwennie gets paid to answer Office usage questions like this at PCHelps.
__________________
"Neither can his Mind be thought to be in Tune,whose words do jarre; nor his reason In frame, whose sentence is preposterous..."
Last edited by MaggieL; 05-26-2006 at 12:21 PM.
|