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)...

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)...

Shane:

Thanks for attention. I'm new at this and hope the below information will
be helpful of your understanding on what I'm trying to accomplish.

This spreadsheet is for tracking monthly income incorporated with accounts
payable.

e2 =sum(a2+b2) while e2 retains last value when entering new values in a2 &
b2 updating e2 in the process...

"Shane Devenshire" wrote:

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)...