+ Reply to Thread
Results 1 to 2 of 2

Google Sheets Macro?

  1. #1
    Registered User
    Join Date
    09-08-2015
    Location
    usa
    MS-Off Ver
    2010
    Posts
    73

    Google Sheets Macro?

    I am not sure if this is a Macro or even possible in google sheets. In my sheet I have numerous rows of information with one column with a quantity, at some point i give the cell with the quantity a background fill color of yellow. Not the whole column just certain cells. Is there anyway to automate the process of taking that entire row that has the highlighted cell and move it to another sheet in google sheets? Ultimately deleting it off the original sheet? Hope I made sense.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Google Sheets Macro?

    You make perfect sense but Google Sheets does not use VBA but GAS (Google Apps Script), a Javascript based code.

    I'm not sure if anyone here has knowledge of that. (I for one don't) so I cannot help you further with this.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Google Sheets File Import Macro
    By Mrneski in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-29-2020, 08:17 AM
  2. Convert VBA Macro code to google sheets macro
    By dorabajji in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2019, 09:35 PM
  3. Google Sheets - Deleting Columns in a Macro Or Script
    By sjgidman82 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-27-2019, 04:52 PM
  4. Sheet Specific Macro (Google Sheets)
    By Sam_Alex in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 11-02-2018, 07:59 AM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. VBA macro in google sheets
    By catscats11 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-01-2017, 01:48 PM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

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