I have two cells, time & sum, which changes after every 5 minutes. I want to copy these cells after every 5 minutes and paste it in a new line every time in order to make a list of old values.
Source cells: | Time | Sum | | 09:30 | 12345 | Expected list: | Time | Sum | | 09:15 | 12345 | | 09:20 | 67891 | | 09:25 | 12345 |
In MS Excel, we can include module and add VB function for this, but I didnt find it in Calc. Is there any alternate way to do this?