Retaining old data values?

  • Thread starter Thread starter udman
  • Start date Start date
U

udman

This is my first post so be gentle please,

I have a sheet with a column of numbers and a cell to the right whic
holds the sum of those numbers. What I want is to have another cel
that contains that same sum, but does not change when the data in th
column of numbers changes. Is that possible?

Thank
 
Sure... just copy the cell that contains the sum, and
paste SPECIAL - Values into the cell you don't want to be
chaned.
 
and you could set up a macro by going to tools > macros > record ne
macro

and select that sum and paste special as he says, then go to tools
macros > stop recording

then create a button from the forms toolbar and assign the macro.
Then it will update it every time you want it to with on
click....sorry i'm into using macro's and buttons at the moment as
result of my ict projec
 
Ginga thanks!!

I knew how to do all of that but I just hadn't pieced the two step
together. Worked like a charm..
 
Back
Top