Okay this is a complicated excel question (i think)

So I have a bunch of data appearing on a page called "Data" that
contains data on different Companies in a certain market place. It has
data like market size, earnings, growth, etc.

So anyway, this data is listed vertically (that is to say, the company
names appear across the top row and the fields (such as market size,
earnings, growth) appear down each column)

The very top row on "Data" contains the Company's ticker (stock
symbol). Now what I would like to do is be able to click a ticker on
that page (maybe through a hyperlink?) and have that ticker appear in
cell "A1" of a sheet called "Home". Does that make sense? Basically
suppose I clicked on cell F1 on the "Data" page, which contained the
ticker IBM. I want the ticker "IBM" to then appear in Cell "A1" of a
sheet called "Home." Now I could go back to the "Data" page and click
cell F2 (which contains the ticker MSFT, for example) and then cell
"A1" in sheet called "Data" would change its value to "MSFT".

Is this possible to have an entire row (Call it row 1) in one sheet
(call it Sheet A) linked to cell A1 of another sheet (call it Sheet B),
whereby clicking on any cell in (Row 1) of (Sheet A) will make the value
of cell A1 in Sheet B become the value you clicked on?

I probably overexplained this, but I dont know how to easily explain
this situation.

I know i could use drop down boxes where you choose the Company name
from and then use offset and match, but id like to make it clickable
just because the drop down would be so large


--
nshah
------------------------------------------------------------------------
nshah's Profile: http://www.excelforum.com/member.php...nfo&userid=875
View this thread: http://www.excelforum.com/showthread...hreadid=400613