Copying Cell Results, Not Formulas, Between Worksheets

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?
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
VBA Coding Help for Beginner 0
Excel Formula or VBA Code 2
Vlookup? 1
formula displays as a formula, not as its result 1
Embed the same Excel multiple times 0
Excel Formula question 0
Copy the content of a cell with Formula 1

Top