Get value from another sheet

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
 

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

VBA Coding Help for Beginner 0
Vlookup and return sheet name also 2
Show value from one cell in another cell if today falls between a date range 5
Retrieving values from another sheet 1
VBA for Dependents shortcut menu 0
VBA not selecting worksheet with titles 3
Use cell contents to build sheet reference 6
Macro copy from range 3

Top