+ Reply to Thread
Results 1 to 3 of 3

Google Sheets - Macro to Auto Drag Formulas

  1. #1
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    245

    Google Sheets - Macro to Auto Drag Formulas

    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.

    Please Login or Register  to view this content.
    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.
    Last edited by AliGW; 05-18-2022 at 01:04 PM. Reason: Title tweak.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,648

    Re: Google Docs - Macro to Auto Drag Formulas

    Your title says Google Docs - I'll change it to Google Sheets (which is what I think you meant).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    797

    Re: Google Sheets - Macro to Auto Drag Formulas

    My recommendation would be to use ARRAYFORMULAS instead.

    These can even be "hidden" inside the header cell.

    It should be noted that there are situations where an ARRAYFORMULA will not work. MINIFS is a good example.

    On the other hand, it is possible to use alternative functions to get the required results when the function does not normally work with an ARRAYFORMULA, for example MAXIFS can be replaced with a SUMPRODUCT variation.

    So, if you have a formula that can NOT be converted to an ARRAYFORMULA, or if you just want to insist that formulas be copied down, then yes it is possible to use an Apps Script to do this.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Converting macro from Excel to Google Docs
    By robert26 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 10-15-2021, 04:45 AM
  2. Converting macro from Excel to Google Docs
    By robert26 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2021, 01:59 AM
  3. I can't use this VBA Macro on Google Docs or Excel Online
    By kevb8ll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2018, 06:59 PM
  4. [SOLVED] Formulas work in online Google Docs version but not in offline version
    By virtuosok in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2018, 06:47 AM
  5. converting excel macro into a google docs script??
    By scottatbuckman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2016, 12:47 PM
  6. How to enable Macro in Google Docs
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2015, 11:33 PM
  7. pull certain data from google docs form-produced spreadsheet to other docs
    By MisterCadillac in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-11-2014, 04:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1