Dynamic Worksheet Names
 

Hello,

I would like to make link to different worksheet with name specified in
different column
eg.
A B
1 Sheet1 =SUM(A1!B4:B10)
2 Sheet2 =SUM(A2!B4:B10)

where column A stores names of worksheets and B sums cells from worksheets
from A column.

Thanks for solutions.

Lukasz

One way:

B1: =SUM(INDIRECT("'" & A1 & "'!B4:B10"))



In article ,
"£ukasz Czech" wrote:

Hello,

I would like to make link to different worksheet with name specified in
different column
eg.
A B
1 Sheet1 =SUM(A1!B4:B10)
2 Sheet2 =SUM(A2!B4:B10)

where column A stores names of worksheets and B sums cells from worksheets
from A column.

Thanks for solutions.

Lukasz