General discussion

Locked

How to reference a value in range of cel

By john ·
I have a spreadsheet with a number of worksheets in it. I want cell A2 to A200 to have the value that is from a cell range in another worksheet.
Example:
new.xls has worksheets 1, 2, 3
worksheet 1 is the 'master' with values from worksheets 2(P2:P200) and 3 (M2:M200).
How do I put those cell values from the other worksheets into cells in worksheet 1?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Don't type, point and click

by JimBb In reply to How to reference a value ...

Select the cell where the result should be, type "=", and point to the cell where you want the data to come from, and press enter. You'll see your Excel will build you a formula that looks like this:

=Sheet2!M2

Copy that around, correct references where needed, and off you go.

Jim

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums