linking worksheet1 to worksheet1

Hello:

I need to link two worksheets in seperate files together. The problem is the
tabname on the first worksheet changes everyday. Is there a keyword I can use
to identify the 1st worksheet regardless of its "name"?

Thanks.

Bed

One way:

Make the linked-to cells a named range (select the cell(s) and enter the
name in the Name Box at the left side of the formula bar).

Then instead of

=SUM('[Workbook1.xls]Sheet 1'!A1:J10)

use

=SUM(Workbook1.xls!MyNamedRange)


In article ,
Bed wrote:

I need to link two worksheets in seperate files together. The problem is the
tabname on the first worksheet changes everyday. Is there a keyword I can use
to identify the 1st worksheet regardless of its "name"?

Bed,

Have both workbooks open, and when the name is changed, the link will
properly update.

HTH,
Bernie
MS Excel MVP


"Bed" wrote in message
...
Hello:

I need to link two worksheets in seperate files together. The problem is
the
tabname on the first worksheet changes everyday. Is there a keyword I can
use
to identify the 1st worksheet regardless of its "name"?

Thanks.

Bed