Within Google Sheets, can you utilize a macro that will automatically drag formulas? As an example, in Excel, is use this line in a macro to automatically drag formulas until column "A" is blank.
I'd like to do this within Google Sheets, either as a timer, or upon the sheet being loaded. What happens, several co-workers come in and add new lines and sometimes forget to drag all the formulas down. If I had this on a timer to run every 30 minutes or so, it would automatically fix itself.Please Login or Register to view this content.
Bookmarks