point to a cell in another workbook
 

I have a workbook with several sheet in the book and one sheet that will need
to pul from one of the seperate sheet (same location, just different sheet).
The normal forlmula is ='[sheetname]'!cell. Is there anyway that the sheet
name can reference a data range so that all I have to do is change the value
in the data range to update the formula?

point to a cell in another workbook
 

Look for examples of INDIRECT to do this

Regards

Trevor


"pcox" wrote in message
...
I have a workbook with several sheet in the book and one sheet that will
need
to pul from one of the seperate sheet (same location, just different
sheet).
The normal forlmula is ='[sheetname]'!cell. Is there anyway that the
sheet
name can reference a data range so that all I have to do is change the
value
in the data range to update the formula?