ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Transfer results from a cell (https://www.excelbanter.com/excel-discussion-misc-queries/114019-transfer-results-cell.html)

apesae

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

Carim

Transfer results from a cell
 
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


FloMM2

Transfer results from a cell
 
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.


apesae

Transfer results from a cell
 
Thank u both That was what i was looking for.

"FloMM2" wrote:

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.



All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com