I want to put together a spreadsheet to input all of my future credit card transactions. Obviously, this sheet can get long fast.
I would like to know if it's possible to dedicate a row at the top of the sheet specifically to inputting new data, and having it push that data to the row below it. I don't want to have to scroll all the way down to the bottom of the sheet or have to manually insert a new row for each new transaction at the top of the sheet.
Basically, in visual form, this is what I'm looking to do:
+------------+------------+-----------+
| Date | Payee | Amount |
--------------------------------------
| | | | <- This row is dedicated to inputting new data
--------------------------------------
| 01/01/2020 | Company 1 | $123 |
--------------------------------------
| 01/01/2020 | Company 2 | $96 |
--------------------------------------
| 01/01/2020 | Company 3 | $45 |
+------------+------------+-----------+
When I enter new data into the row, in this case let's say I made a payment of $50 to Company 2 on 02/01/2020, I would like it to push it to the row below, to clear up that row for another input:
+------------+------------+-----------+
| Date | Payee | Amount |
--------------------------------------
| | | | <- This clears up
--------------------------------------
| 02/01/2020 | Company 2 | $50 | <- And my data gets pushed here
--------------------------------------
| 01/01/2020 | Company 1 | $123 |
--------------------------------------
| 01/01/2020 | Company 2 | $96 |
--------------------------------------
| 01/01/2020 | Company 3 | $45 |
+------------+------------+-----------+
How would I go about doing this?
Best Answer
Alternative: use Google Apps Script and a edit trigger
Reference
https://developers.google.com/apps-script/guides/sheets