Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
Suppose Cell A1 houses the formula:
=Sheet2!C23
In Cell A2 I would like to have the value of the cell 10 places to the right of the range referenced in cell A1, to do this manually, the formula would look like this:
=Offset(Sheet2!C23, 0, 10, , )
Is there a clever way for me to pick up the the "Sheet2!C23" part of the formula in A1?
Thanks
=Sheet2!C23
In Cell A2 I would like to have the value of the cell 10 places to the right of the range referenced in cell A1, to do this manually, the formula would look like this:
=Offset(Sheet2!C23, 0, 10, , )
Is there a clever way for me to pick up the the "Sheet2!C23" part of the formula in A1?
Thanks