| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for coping a cell from a diffent sheet
i would like to copy a cell from a different sheet onto the one sheet i am
viewing is there a formula for that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for coping a cell from a diffent sheet
the cell contains TEXT or a word not a number also
"Shallow" wrote: i would like to copy a cell from a different sheet onto the one sheet i am viewing is there a formula for that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for coping a cell from a diffent sheet
You can't copy by formula, but you can link by formula:
=Sheet3!B9 will display the value in B9 on Sheet3 -- Gary''s Student - gsnu200805 "Shallow" wrote: i would like to copy a cell from a different sheet onto the one sheet i am viewing is there a formula for that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for coping a cell from a diffent sheet
SWEET!
THANK YOU "Gary''s Student" wrote: You can't copy by formula, but you can link by formula: =Sheet3!B9 will display the value in B9 on Sheet3 -- Gary''s Student - gsnu200805 "Shallow" wrote: i would like to copy a cell from a different sheet onto the one sheet i am viewing is there a formula for that? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for coping a cell from a diffent sheet
You are welcome!
Be sure to remember that a blank in B9 will display as 0 in the display cell. -- Gary''s Student - gsnu200805 "Shallow" wrote: SWEET! THANK YOU "Gary''s Student" wrote: You can't copy by formula, but you can link by formula: =Sheet3!B9 will display the value in B9 on Sheet3 -- Gary''s Student - gsnu200805 "Shallow" wrote: i would like to copy a cell from a different sheet onto the one sheet i am viewing is there a formula for that? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for coping a cell from a diffent sheet
You can actually copy it that way without any typing, especially handy if
you want to do more than one cell Copy the cell/cells, got to where you want it and do editpaste special and select paste link -- Regards, Peo Sjoblom "Shallow" wrote in message ... SWEET! THANK YOU "Gary''s Student" wrote: You can't copy by formula, but you can link by formula: =Sheet3!B9 will display the value in B9 on Sheet3 -- Gary''s Student - gsnu200805 "Shallow" wrote: i would like to copy a cell from a different sheet onto the one sheet i am viewing is there a formula for that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| coping formula | New Users to Excel | |||
| WHY DOES COPING FROM SHEET TO SHEET INCREASE SIZE DRAMATICALLY? | Excel Discussion (Misc queries) | |||
| Automatic filtering and coping result to a seperate sheet | Excel Worksheet Functions | |||
| Questions on copying from one sheet to the other and coping every other cell. | Excel Discussion (Misc queries) | |||
| formula coping 5 consecutive cell triggered by a value from anoth. | Excel Discussion (Misc queries) | |||
Linear Mode
