keeping sum after deleting the added numbers
 

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.

keeping sum after deleting the added numbers
 

At the end of the month, copy and paste it to another tab?

"Brett" wrote:

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.

keeping sum after deleting the added numbers
 

I was hoping that I wouldn't have to do that. I just want to delete the
information that I added without losing the sum

"dlw" wrote:

At the end of the month, copy and paste it to another tab?

"Brett" wrote:

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.

keeping sum after deleting the added numbers
 

OK,

If you delete the data, the sum will be zero. the only way is, copy and
paste special values, but have notice that you will lose the formula and to
sum the next month data you will to edit using:

assuming that the total of the first month was 123.456,00

you will have =123456+sum(b2:b6000)

hth

regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:

I was hoping that I wouldn't have to do that. I just want to delete the
information that I added without losing the sum

"dlw" wrote:

At the end of the month, copy and paste it to another tab?

"Brett" wrote:

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.

keeping sum after deleting the added numbers
 

Thanks

"Marcelo" wrote:

OK,

If you delete the data, the sum will be zero. the only way is, copy and
paste special values, but have notice that you will lose the formula and to
sum the next month data you will to edit using:

assuming that the total of the first month was 123.456,00

you will have =123456+sum(b2:b6000)

hth

regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:

I was hoping that I wouldn't have to do that. I just want to delete the
information that I added without losing the sum

"dlw" wrote:

At the end of the month, copy and paste it to another tab?

"Brett" wrote:

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.

keeping sum after deleting the added numbers
 

happy to help, tanks for the feedback


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:

Thanks

"Marcelo" wrote:

OK,

If you delete the data, the sum will be zero. the only way is, copy and
paste special values, but have notice that you will lose the formula and to
sum the next month data you will to edit using:

assuming that the total of the first month was 123.456,00

you will have =123456+sum(b2:b6000)

hth

regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Brett" escreveu:

I was hoping that I wouldn't have to do that. I just want to delete the
information that I added without losing the sum

"dlw" wrote:

At the end of the month, copy and paste it to another tab?

"Brett" wrote:

Monthly I pull data and then autosum for a particular month. I want to use
the same tab to put the pulled data on each month and keep the lasts months
data on another tab with the monthly autosum totals.