Fetching data from another worksheet
Assume your two worksheets are named Sheet 1 and Sheet 2, and you want
to get data from cell B1 of Sheet 2 and put it into cell A1 of Sheet
1. Enter this formula in cell A1 of Sheet 1:
='Sheet 2'!B1
That's all there is to it. Obviously, you should adjust the cell
references and sheet names to suit your circumstances.
Hope this helps.
Pete
|