Zaboravite Microsoft Macro, koristite google [.gs] google script language i google drive

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