Hello. I've messed up with the possibility with daily saves. I need automatically every day (any hour) save a huge amount of cells, to have a precise history. The problem is that the previous day is just not going to be saved. And I have to copy_paste all cells daily. For example:Any ideas? Thank you.
Mac mini, macOS 12.4
Sorry but there is no automated way to do this.
I have a budget sheet where I do something similar.
I have on row for each month, in this row I have multiple columns with the different bank accounts and exchange rate for Euro / US$. At the last day of each month I do copy paste for this row and copy the row with command + c and paste it with shift + command + v to have the fixed values for this month in this row.
If you are familiar with Apple script you could write a script that is doing exactly this, as soon as you start the script manually.
Problem with formulas like TODAY or NOW is that they will change the next day, therefore it will not work.
Today the formula TODAY will return Jun 16 2022, if you run it tomorrow it will give you Jun 17 2022.
I agree with SG, every hour / day a huge amount of cells will generate a gigantic amount of row / cells within very short time.
Numbers may not her the best tool to record / store gigantic amounts of data.
Ralf
Sorry but there is no automated way to do this.
I have a budget sheet where I do something similar.
I have on row for each month, in this row I have multiple columns with the different bank accounts and exchange rate for Euro / US$. At the last day of each month I do copy paste for this row and copy the row with command + c and paste it with shift + command + v to have the fixed values for this month in this row.
If you are familiar with Apple script you could write a script that is doing exactly this, as soon as you start the script manually.
Problem with formulas like TODAY or NOW is that they will change the next day, therefore it will not work.
Today the formula TODAY will return Jun 16 2022, if you run it tomorrow it will give you Jun 17 2022.
I agree with SG, every hour / day a huge amount of cells will generate a gigantic amount of row / cells within very short time.
Numbers may not her the best tool to record / store gigantic amounts of data.
Ralf
Not sure exactly what you mean about "saving cells".
Tables have cells. Tables are in a document, which gets saved.
Perhaps you are trying to date stamp? If so, keep in mind that you can insert there current date-time by clicking a cell and from the menu choosing Table > Insert Date or Table > Insert Time. Each of these has keyboard shortcuts for potentially quicker entry.
You should also keep in mind that Numbers may not be the best tool for a "huge amount of cells". Hundreds or thousands ok. But Numbers may become sluggish if you have a "huge amount."
SG
.
I'm still not sure what you are trying to do.
Do you mean you need to manually enter a new row of (three) cells each hour, at the bottom of the existing rows of three cells?
If you mean that, then there may be an easy solution.
SG
Thank you for communication)) I mean that I need to freeze formula result from the previous day, when the next day comes.
But I have the disappearing previous day results (as the function "TODAY" works only for now)Here is the illustration below of "B" column - how it is should be look like, and "C" column how it is really working.
Sorry, I meant to save result of the cell.
Thank you) my brain was boiled to think about the possible way to solve this problem. But there is no way, as you said. I'm not familiar with Apple script, so.
Numbers: saving cells every day.
