Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Question
Can someone help a newB about how to copy a cell (which contains a count
formula) to another worksheet. I need it to just copy the # so it can go into a worksheet that is totaling order #'s? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Question
1) Copy the cell with the formula in it showing the value you want
2) Switch to the other sheet and select the target cell (do not press ENTER on it) 3) Click on EDIT PASTE SPECIAL Values That should paste in just the value of the formula, not the formula itself. Does that help? -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "DBarker10" wrote: Can someone help a newB about how to copy a cell (which contains a count formula) to another worksheet. I need it to just copy the # so it can go into a worksheet that is totaling order #'s? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Question
Another solution - Go to the cell that you want the number in
hit the "=" key. Use the mouse and go to the sheet that has the number you want copied Select that cell with your mouse hit enter. Done - this way these two numbers will always be in-sync.... -- Wag more, bark less "DBarker10" wrote: Can someone help a newB about how to copy a cell (which contains a count formula) to another worksheet. I need it to just copy the # so it can go into a worksheet that is totaling order #'s? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Question | Excel Discussion (Misc queries) | |||
Excel question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |