Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup cell value using list of worksheet names | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Extracting worksheet names.... | Excel Worksheet Functions | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |