Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
no formula results in cell | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |