More efficient way of adding to current numeric value (decimal currency) in cell in Google Sheets?

Long story short, I have in Google Sheets a spreadsheet for my personal budget/cashflow tracking, which has one accounting month per column and one category of income and expense per row. After I buy something, I have to add the amount of the purchase to the cell for the category of the expense in the column for the current accounting month, which is the same as my credit card billing period instead of the calendar month because it is much easier that way because I buy most things using my credit card account. I usually get the amount of the purchase from the recent transactions in my credit card account on the Web site of my credit card company, then use the Run dialog on Windows as a temporary buffer to manually/mentally add the amount of the purchase to the current value of the cell or use SpeedCrunch or IDLE for Python 2.7 (Python 2.7 for ever, even if it is now finally officially EOL) to have the computer add the amount of the purchase to the current value of the cell, then paste the new value into the cell. Since I usually do this manual process at least once every day, I thought I should finally get around to asking if there is a way, using the Web version of Google Sheets in Vivaldi on Windows 10 Enterprise for x86-64, that I can somehow partially automate this process so I can just copy and paste the amount of the purchase from my credit card account into the cell in Google Sheets and have the software automatically add the pasted value to the value of the cell in Google Sheets? I occasionally use Google Sheets for Android on my handheld computer to edit this same spreadsheet while I am away from my home and office but I will not worry about improving the efficiency of this process on my handheld computer for now because I am usually only doing this process on my home computer or office computer. Yes, I should ideally be using actual accounting software instead of a spreadsheet but Google Sheets works better for my use case because then I always have the current version of my document on all of my computers (stationary computer at home, stationary computer at office, handheld computer) without having to remember to do anything special, such as exit GnuCash on my home computer before going to my office or vice versa. In theory, I can remotely control my home computer from my office computer and vice versa to run a local/native accounting application but, in practice, I cannot reliably remotely control the other computer in either direction. I do not want to use GnuCash for Android, which is a different application than the original, desktop GnuCash and is not even written in the same programming language, because then I can only use the application on one of my computers. Heh, this was supposed to be a short version of my long story but I did try to avoid getting into unnecessary details/specifics.

This seems doable. I would suggest googling “google sheets automation”.

I searched the Internet with both DuckDuckGo, which I primarily use, and Google Search, which I occasionally still use, found some interesting articles and discovered the alternating colours and heat map features of Google Sheets but did not find any mention of what I wanted to do and think I have probably spent more time discussing and researching this issue than I would save even if I am able to do it after all.

1 Like

directly paste + add to current value in a sheet doesn’t work AFAIK. However, you could create a second sheet and do a column sum of the second sheet in your first sheet, so you append a row in the second sheet each time you go to paste a new value.

Sheet1:
-cell A1=Sheet2!sum(A1:A1000)

Sheet2:

  • column A, append values
1 Like