Copying Cell Results, Not Formulas, Between Worksheets

  • Thread starter Thread starter clouts
  • Start date Start date
C

clouts

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?
 
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
 
Back
Top