View Single Post
  #3   Report Post  
Old August 29th 05, 09:47 PM
Mike
 
Posts: n/a
Default

sample:
=Sheet2!B4

So in general
WORKSHEETNAME!CELL
would work in formulas.

"XLDabbler" wrote:

I would like to concatenate cell values to create a name that corresponds to
a worksheet name and then use that in a formula. Does anyone know how to do
this?