cell value as a worksheet reference

G

Guest

I am trying to create a worksheet that consolidates data from a set of other
worksheets. The other sheets are all formatted identically. What I am having
difficulty with is using the name of the other tabs in my formulas in the
summary tab. I have the name of the tab in the a cell but can't figure out
how to use that cell value as a worksheet reference. For example, in the
summary tab, A2="Source1" but I get an invalid formula error when I enter
this into B2: =(a2)!b17. Any help would be appreciated...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Named Ranges and Dynamic Formulas 3
How to Auto Reference Worksheet Tab ID's in Formulas? 9
linking a worksheet by a cell reference 3
How do I use the text content of a cell as a worksheet reference? 9
lookup and worksheet name and then do formula 2
How to use a cell value to reference a worksheet name 2
Reference other worksheet 4

Top