On 2002-02-19 16:30, dngidotcom wrote:

Followup:

Thanks for the help above. These are the equations I used:

=INDIRECT("'["&filename!$C$2&"(H).xls]Sheet2'!$A$1:$X$33")

=INDIRECT("'["&filename!$C$2&"(G).xls]Sheet2'!$A$1:$X$33")

...

=INDIRECT("'["&filename!$C$2&"(B).xls]Sheet2'!$A$1:$X$33")

=INDIRECT("'["&filename!$C$2&"(A).xls]Sheet2'!$A$1:$X$33")

and

='[PE-75-1(H).xls]Sheet2'!$A$1:$X$33

='[PE-75-1(G).xls]Sheet2'!$A$1:$X$33

...

='[PE-75-1(B).xls]Sheet2'!$A$1:$X$33

='[PE-75-1(A).xls]Sheet2'!$A$1:$X$33

You'll notice several fils with A-H being the difference in the file names. However, A-H are also the worksheet names where these equations are used. For example, on Worksheet A, the equation is:

='[PE-75-1(A).xls]Sheet2'!$A$1:$X$33

Is there any way to get that "A", the name of that Worksheet, into that equation with some reference equation such as "Sheetname" instead of manually entering A, B, C... etc into the equation on the different Worksheets, A-H?

Also, in those equations you'll see "Sheet2", is there anyway to use a reference for the 2nd sheet in the workbook, because the worksheets don't always have that name "Sheet2", so in those instances I need to go in and manually rename the sheets.

Thank you.

Paul

## Like this thread? Share it with others