Get value from another sheet

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi All,

In Cell A1 I have the name of a worksheet, e.g. MySheet. In Cell B1 I want
to get a value from MySheet. How do I write a function in B1 to get
MySheet!C1 for example. When I copy the function to cell B2 it would get the
value MySheet2!C1 - if MySheet2 is written in A2. I tried using ADDRESS(...)
but it writes as text MySheet!C1 in the cell whereas I want the value.

I hope that makes sense,

Rob
 
Back
Top