I am using Microsoft excel only not Google Sheet because I think there you can not run macros or may be I am wrong because I never use it.
Once I sent some files to my friend with button but on Google Sheet It was not active.
Writing Macros in VBA is very easy, not so hard but you just need to know basic of programming(not necessary VBA) and off Couse visualising the action in prospect of computer(complier).
I am using lot of Macros but I never face any difficulty for updating. With the help of macros life become very easy. I am having macros for everything. In my excel sheets I never use to do manual entries.