Refrencing and Linking Worksheets

J

jerm

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top