A
apesae
I need to transfer results from a cell in a different work sheet If anyone
coyld help i would apriciate it.
coyld help i would apriciate it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Carim
Hi,
In the worksheet where you want your result
1. just type the sign =
2. then, with your mouse, go to the "source" worksheet, select the
cell and press Enter
That' it ...
HTH
Carim
In the worksheet where you want your result
1. just type the sign =
2. then, with your mouse, go to the "source" worksheet, select the
cell and press Enter
That' it ...
HTH
Carim
F
FloMM2
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.
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.
A
apesae
Thank u both That was what i was looking for.
FloMM2 said: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.