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
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