Link with Data
 

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

Link with Data
 

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

Link with Data
 

VBA would be your solution.

I believe that when you click on the link the excel cell pointer stays in
the cell with the link. All you would have to do then is on the worksheet
activate to look at the cell value on your calling sheet do some string
manipulation and retrieve the customer number.

you could also use the worksheet selectionchange event to store the customer
number in a variable and then retrieve it on the worksheet activate event.

--
Rui

"C Brandt" wrote in message
...
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

Link with Data
 

Chad:

Thanks for your suggestion.
Is there a way to execute a macro when you select a specific cell?

Craig


"Chad" wrote in message
...
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