View Single Post
  #1   Report Post  
Łukasz Czech
 
Posts: n/a
Default 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