Hello,

I have an API data connection in Sheet 1. In Sheet 2, I have a formula to count the number of a specific value in a column from Sheet 1.

I want to scheduled a refresh daily to update the API data, record the new count cell value as a new row and timestamp the current date.

The result should be similar to this:

1/17/2021 252
1/18/2021 261
1/19/2021 259

I have found a macro to timestamp in one column when a value is added to another. I have also found code to record the value to a new row, however it only runs when manually triggering the macro.

Any suggestions or examples would be greatly appreciated!