| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to keep a changing value
I have a payroll speadsheet. It works well, but I would like to keep
year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to keep a changing value
Perhaps you could just Archive the file occasionallly, by doing a File
SaveAs ....and using a different name with a date code..........then you could retrieve the data you need from any one of them. Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I have a payroll speadsheet. It works well, but I would like to keep year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to keep a changing value
I appreciate the info. If I cannot find any other way to do it, I will make
that work. I would rather do it all with one file, if possible. I guess my real question is: Is there any way to save data into a seperate cell before the data changes? "CLR" wrote: Perhaps you could just Archive the file occasionallly, by doing a File SaveAs ....and using a different name with a date code..........then you could retrieve the data you need from any one of them. Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I have a payroll speadsheet. It works well, but I would like to keep year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to keep a changing value
To do it manually......
Copy PasteSpecial Values Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I appreciate the info. If I cannot find any other way to do it, I will make that work. I would rather do it all with one file, if possible. I guess my real question is: Is there any way to save data into a seperate cell before the data changes? "CLR" wrote: Perhaps you could just Archive the file occasionallly, by doing a File SaveAs ....and using a different name with a date code..........then you could retrieve the data you need from any one of them. Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I have a payroll speadsheet. It works well, but I would like to keep year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to keep a changing value
thanks. manual won't work, because I will not be the one using it and I would
have to do it manually for every field. I could just type it in as fast. I have experimented with the IF function and could use it, if someone knows how to make it so that the cell's value does not change the if the condition is not true. "CLR" wrote: To do it manually...... Copy PasteSpecial Values Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I appreciate the info. If I cannot find any other way to do it, I will make that work. I would rather do it all with one file, if possible. I guess my real question is: Is there any way to save data into a seperate cell before the data changes? "CLR" wrote: Perhaps you could just Archive the file occasionallly, by doing a File SaveAs ....and using a different name with a date code..........then you could retrieve the data you need from any one of them. Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I have a payroll speadsheet. It works well, but I would like to keep year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to keep a changing value
Do you continue adding to the payroll sheet, or does the weekly data
change and it's only one week listed at a time? On Jan 3, 3:09 pm, TomH wrote: thanks. manual won't work, because I will not be the one using it and I would have to do it manually for every field. I could just type it in as fast. I have experimented with the IF function and could use it, if someone knows how to make it so that the cell's value does not change the if the condition is not true. "CLR" wrote: To do it manually...... Copy PasteSpecial Values Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I appreciate the info. If I cannot find any other way to do it, I will make that work. I would rather do it all with one file, if possible. I guess my real question is: Is there any way to save data into a seperate cell before the data changes? "CLR" wrote: Perhaps you could just Archive the file occasionallly, by doing a File SaveAs ....and using a different name with a date code..........then you could retrieve the data you need from any one of them. Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I have a payroll speadsheet. It works well, but I would like to keep year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to keep a changing value
Only one week at a time. I have a list of fields to store the weekly values
in, based on the date. The problem is (of course) that the values are only there when the date is correct. "iliace" wrote: Do you continue adding to the payroll sheet, or does the weekly data change and it's only one week listed at a time? On Jan 3, 3:09 pm, TomH wrote: thanks. manual won't work, because I will not be the one using it and I would have to do it manually for every field. I could just type it in as fast. I have experimented with the IF function and could use it, if someone knows how to make it so that the cell's value does not change the if the condition is not true. "CLR" wrote: To do it manually...... Copy PasteSpecial Values Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I appreciate the info. If I cannot find any other way to do it, I will make that work. I would rather do it all with one file, if possible. I guess my real question is: Is there any way to save data into a seperate cell before the data changes? "CLR" wrote: Perhaps you could just Archive the file occasionallly, by doing a File SaveAs ....and using a different name with a date code..........then you could retrieve the data you need from any one of them. Vaya con Dios, Chuck, CABGx3 "TomH" wrote: I have a payroll speadsheet. It works well, but I would like to keep year-to-date totals. My problem is that my weekly totals are not static (they come from a formula). The weekly totals change every week but I cannot figure out how to store them for my Y-T-D sums. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
| Changing n/a to zero | Excel Discussion (Misc queries) | |||
| changing a cell to changing the link | Excel Worksheet Functions | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| changing #value! to 0's | Excel Worksheet Functions | |||
Linear Mode
