Using INDIRECT to reference cell in another worksheet 
Author Message
 Using INDIRECT to reference cell in another worksheet

I am having trouble with the following:

I have 24 Identical workbooks with Identical formula setups. I am modifying
the summary sheet to include only the data from sheets that I am interested.
I have seen the solution on this newsgroup before but am still missing
something. This is what I have so far...

INDIRECT("m7")&"!v14"

M7 has the string I want to reference the worksheet name and V14 is the cell
reference desired. It is giving the proper text string but not returning the
values from the cell.

Any consideration would be greatly appreciated.

GS



Wed, 18 Jun 1902 08:00:00 GMT  
 Using INDIRECT to reference cell in another worksheet
Hi Guy.

In  cell  m7  you enter the sheet name, say    Sheet1    and you want to
reference cell v14 on that worksheet,  the formula would be:
=INDIRECT(M7&"!V14")

If the sheet name has spaces in the name say  Sheet One   the formula would
then be:
=INDIRECT("'"&M7&"'!V14")   or use      'Sheet One'   in cell M7 and the
formula would be as the first one.

Hope that's not confusing.......

All the Best

George
Microsoft MVP - Excel

Newcastle upon Tyne
England.

Quote:

> I am having trouble with the following:

> I have 24 Identical workbooks with Identical formula setups. I am
modifying
> the summary sheet to include only the data from sheets that I am
interested.
> I have seen the solution on this newsgroup before but am still missing
> something. This is what I have so far...

> INDIRECT("m7")&"!v14"

> M7 has the string I want to reference the worksheet name and V14 is the
cell
> reference desired. It is giving the proper text string but not returning
the
> values from the cell.

> Any consideration would be greatly appreciated.

> GS



Wed, 18 Jun 1902 08:00:00 GMT  
 Using INDIRECT to reference cell in another worksheet
Thanks George. Works great.

GS

<snip>



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Linking a cell to another worksheet using a worksheet name reference

2. Problems using INDIRECT to reference cells in another workbook

3. using indirect() to build a cell reference?

4. Cell referencing using INDIRECT in a VLOOKUP formula

5. Renaming a worksheet using the data from a cell reference point

6. Referencing Worksheets using contents of other Cell

7. Help: Using cell text to reference another worksheet

8. Referencing Worksheets via Indirect Function - Excel 97-SR2

9. Worksheet Tab Name = Cell reference in worksheet?

10. Summing using formulas already in cells, not cell references, or values in cells


 
Powered by phpBB® Forum Software © phpBB Group