Help on index addressing using variable sheets & cell references


G

Guest

I wish to reference data in variable cells, on variable worksheets, from a
fixed worksheet :

Sheet 1.A1 = name of variable worksheets (Sheet 2, Sheet 3 ...) to get data
from
Sheet 1.A2 = variable row on chosen variable worksheet to get data from
The column on the variable worksheet will always be the same, say "B"
Data to be displayed in Sheet 1.A3

All the forum Q/As I have seen reference fixed cells on Sheet 2,3 etc, not
variable.
cells. I would also be interested to know the formula if the row was fixed
and the column was variable.

Can anyone help ?
 
Ad

Advertisements

Ad

Advertisements

G

Guest

The 'more robust' approach of using single quotes worked, as the worksheet
names have a space in them.

Many thanks
 

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