linking worksheet1 to worksheet1

[Bed]

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

 

[JE McGimpsey]

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)

 

[Bernie Deitrick]

Bed,

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

HTH,
Bernie
MS Excel MVP