Try this:
Open both worksheets, Sheet1(datasource) & Sheet2 (resultdata)
Select the Sheet2 where you want the data to show up. Select which cell you
want the data in. Select the "=" (without the ""). Now select the datasource
Sheet1, locate the cell that has the data you want transfered. It will
automatically shift back to Sheet2 and look like this "=Sheet1!A6" , if you
selected A6 on Sheet1.
Hope this helps.
"apesae" wrote:

I need to transfer results from a cell in a different work sheet If anyone
coyld help i would apriciate it.