I’m trying to check if a cell A1 has changed or edited, then populated cell B1 with change date, I’ve seen tips over the internet using macro, is there any other way that I can do this without using macro?
In one word - then "No"
In more detail - one of the principles of spreadsheets is the rule “each cell in the table is responsible only for its own content and does not affect the content of other cells until they themselves want to.” In other words, the cell B1 with the modified date will not change after cell A1. Only the use of a macro can get around this limitation. Any dirty hacks that do this through iterative calculations and tricky cell comparisons to themselves and seem to do the job may stop working at any moment, don’t rely on it.
1 Like
thanks for your explanation.
With macro only.
The solution is here. It can be adapted to your task, if it suits you in principle. Let me know.
thanks, will take a look and let you know.
WIthout macro, a database can record every input into a form as a new record with time stamp, so you do not lose any previous information.
counter.odb (23.5 KB)
Open the document, then the embedded input form and enter some numbers. Then go to the report section in the database window, open the report.
thanks for the tips, will take a look.
A slightly more elaborate example counting different ingoing and outgoing items with timestamp.
One form for for quick input of ingoing items.
Another one for for quick input of outgoing items.
And another form with in/out of selected items side by side.
Plus reports for history and current balance.
https://forum.openoffice.org/en/forum/download/file.php?id=28761
Thanks, will take a look.