Hello,

I have the name of my worksheets in a list.

I want to refrence a column in each workheet depending on the
selection of the item in the list.

For example, i have worksheetA, worksheetB and worksheetC. The item
in each work sheet i want to nab is in B7.
Thus when the user selects worksheetA from the list i want to do
something like the following

=workSheetA!B7 <- this works great.

my list is in cell A1 on a worksheet called main. Thus A1 has the
following choices worksheetA,worksheetB,worksheetC.

If i try doing somehting like this:
=A1!B7

it doesn't work.

How would I take the string in A1, which is an item in a list of all
worksheets and make it such that i can refrence that cell...

jerm

Hi jerm

See this page
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jerm" wrote in message oups.com...
Hello,

I have the name of my worksheets in a list.

I want to refrence a column in each workheet depending on the
selection of the item in the list.

For example, i have worksheetA, worksheetB and worksheetC. The item
in each work sheet i want to nab is in B7.
Thus when the user selects worksheetA from the list i want to do
something like the following

=workSheetA!B7 <- this works great.

my list is in cell A1 on a worksheet called main. Thus A1 has the
following choices worksheetA,worksheetB,worksheetC.

If i try doing somehting like this:
=A1!B7

it doesn't work.

How would I take the string in A1, which is an item in a list of all
worksheets and make it such that i can refrence that cell...

jerm