here's a thought: rather than using a hyperlink, you could think about
running a macro after pressing a button on the initial sheet. within the
macro, write in an input box that will prompt for the account #. after
obtaining the account #, you can pull in the pertinent info for that specific
account and put the data on the account specific sheet.

hope this helps,
-chad

"C Brandt" wrote:

I see that you can apply a "Hyperlink" to a cell in a workbook, that when
clicked, will send you to another page in the same workbook. Is there a way
to take the contents of the linking cell to the distination.

I have a large Spreadsheet with many clients. The data for eack client can
be substantual and spread across a single row. I would like to be able to go
to this list, click on the client account number and be taken to another
spreadsheet with only that client's information displayed in a neat form.

From my viewpoint, that could be done by creating a hyperlink, established
on each of the client's account numbers, linking it to a generic spread
sheet that would display only that client's information. For this to work,
you would need to take the account number with you to the generic form so
the form could go back and lookup all the pertinant data from the source and
display it on a single, easy-to-read form.

Any ideas?

Craig