linking worksheet1 to worksheet1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Bed,

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

HTH,
Bernie
MS Excel MVP
 
Back
Top