Using INDIRECT to reference cell in another worksheet
In cell m7 you enter the sheet name, say Sheet1 and you want to
reference cell v14 on that worksheet, the formula would be:
If the sheet name has spaces in the name say Sheet One the formula would
=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
Microsoft MVP - Excel
Newcastle upon Tyne
> I am having trouble with the following:
> I have 24 Identical workbooks with Identical formula setups. I am
> the summary sheet to include only the data from sheets that I am
> I have seen the solution on this newsgroup before but am still missing
> something. This is what I have so far...
> M7 has the string I want to reference the worksheet name and V14 is the
> reference desired. It is giving the proper text string but not returning
> values from the cell.
> Any consideration would be greatly appreciated.