C
Cindy
We have a spread sheet - htm - end project will be working with 90,000
records - broken into about 90 different spreadsheets...
ColumnA - will be hyperlinked to column K
Column A will contain a ID number - 15 numbers
Column K will contain --- c:\(the same 15 numbers as above).pdf
Column A should read... =hyperlink(K1, "the 15 numbers")
questions - I've been playing with this all day and can't quite get it to
work...
Can I somehow pull those 15 numbers out to represent the friendly name?
(from between the c:\ and the .pdf )
IF I could do that - then I should be able to "copy down" the formula to
fill in the rest of the sheet?
If anyone has any ideas that might help me - I would sure appreaciate some
help!!! thanks in advance for your time!!!
Cindy
records - broken into about 90 different spreadsheets...
ColumnA - will be hyperlinked to column K
Column A will contain a ID number - 15 numbers
Column K will contain --- c:\(the same 15 numbers as above).pdf
Column A should read... =hyperlink(K1, "the 15 numbers")
questions - I've been playing with this all day and can't quite get it to
work...
Can I somehow pull those 15 numbers out to represent the friendly name?
(from between the c:\ and the .pdf )
IF I could do that - then I should be able to "copy down" the formula to
fill in the rest of the sheet?
If anyone has any ideas that might help me - I would sure appreaciate some
help!!! thanks in advance for your time!!!
Cindy