Hi,

I don't follow this - you want one cell to retain two different values the
YTD and the YTD plus added data?

Maybe you had better explain with an example.

What it appears you are asking can't be done in the spreadsheet, except
possibly with VBA.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Linebacker" wrote:

How do you lock a cell value ($) to show continuous updating of income (i.e.,
YTD income) when copying and pasting spread sheet. After copying and
pasting, I would like for the YTD income value to maintain last known value
while also accepting new addition(s)...