General discussion
-
Topic
-
How to reference a value in range of cel
LockedI 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?