View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clouts clouts is offline
external usenet poster
 
Posts: 1
Default 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?