| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zeros are being added to my numbers | New Users to Excel | |||
| added up none numbers | Excel Worksheet Functions | |||
| Removing characters from a cell (keeping only the numbers) | Excel Discussion (Misc queries) | |||
| How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added? | Excel Worksheet Functions | |||
| Find the combination of numbers that when added equal a reqired total?? | Excel Worksheet Functions | |||
Linear Mode
