0

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?

New contributor
user698515 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
0
  1. Enable the compatible keyboard shortcuts (Help > Keyboard shortcuts)
  2. Press Ctrl + + to insert a row

Alternative: use Google Apps Script and a edit trigger

Reference

https://developers.google.com/apps-script/guides/sheets

|improve this answer|||||

Your Answer

user698515 is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for?Browse other questions tagged or ask your own question.