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. |
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 |
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. |
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