Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Cell Results, Not Formulas, Between Worksheets
What I am trying to do is to copy the results of a cell, not the actual
formula, into a new worksheet. For further explanation, I am using a monthly budget and the last cell, for example, is C65. I want to take that number and put it into C1 of the next sheet. Now, it wants to move the formula. Can I move just the number, so I can keep a rolling change throughout the remaining months? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Cell Results, Not Formulas, Between Worksheets
One way,
Try this in C1 of your sheet =TEXT(LOOKUP(99^99,Sheet1!C:C),"0.00")+0 this will grab the last number in column C of sheet 1 Mike "clouts" wrote: What I am trying to do is to copy the results of a cell, not the actual formula, into a new worksheet. For further explanation, I am using a monthly budget and the last cell, for example, is C65. I want to take that number and put it into C1 of the next sheet. Now, it wants to move the formula. Can I move just the number, so I can keep a rolling change throughout the remaining months? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Cell Results, Not Formulas, Between Worksheets
Copy, then go to your destination cell and Edit/ Paste Special/ Values.
-- David Biddulph "clouts" wrote in message ... What I am trying to do is to copy the results of a cell, not the actual formula, into a new worksheet. For further explanation, I am using a monthly budget and the last cell, for example, is C65. I want to take that number and put it into C1 of the next sheet. Now, it wants to move the formula. Can I move just the number, so I can keep a rolling change throughout the remaining months? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying formulas from worksheets | New Users to Excel | |||
Copying Formulas Between Worksheets | Excel Discussion (Misc queries) | |||
Copying Formulas in Excel 2003 (The results Dont Change) | Excel Discussion (Misc queries) | |||
Copying formulas without changing previous results/calculations | Excel Worksheet Functions | |||
Copying options: contents, results, formulas, etc. | New Users to Excel |