Hi, I need some help with importing information from 2 different workbooks
into a third one. The problem that I have is the following: the reference
points from where the information needs to be pulled from are not the same
cells every day but information in column A that point ...

is it possible to return this kind of string from the indirect function
(to use in a LOOKUP function):
'VARIABLE'!B$13:B$46
where VARIABLE is in the cell A1, and gives me the worksheet to lookup

I am  trying to find how do I make a cell so as to when I click on it, It
automatically launches a stored PDF file that I have in another directory.  
Hyperlink does not seem to be working??

I see questions about this all over this group, but no answers.  When I
goto Edit Links, the Change Source button is greyed out.  It was
working just yesterday!??
What is the reason for this?

I have a user who is running Excel 2003. He has a sheet that is nothing but
hyper links and notes about what those links are. When a doc is linked and
the document saved the link is no longer working. Here is what the link
looks like before and after save.

I have a worksheet with cells linked to files contained in the same folder
as the spreadsheet file. When I created the hyperlinks, the full path was
included. I want to burn the files and spreadsheet to a CD, so want the
hyperlinks to be relative, not containing the absolute path of ...