convert cell value into name either to call a tab or a named array
To fill up a table, I need to gather values from multiple tabs; for each row a different tab.
I added the exact names of the tabs in the first column.
Then I tried =A10!B14 to get the value in the B14 cell of the A10-like named tab. But it does work because Excel sees A10 as a value and not as reference (tab name with the !)
Is there anyway to use the value of a cell as a reference, either for a tab name or an array name?
Many thanks for your help
To fill up a table, I need to gather values from multiple tabs; for each row a different tab.I added the exact names of the tabs in the first column.Then I tried =A10!B14 to get the value in the B14 cell of the A10-like named tab. But it does work because Excel sees A10 as a value and not as reference (tab name with the !) Is there anyway to use the value of a cell as a reference, either for a tab name or an array name? Many thanks for your help Read More
