+ Reply to Thread
Results 1 to 5 of 5

Google Sheets - Copy down down @ times based on another cell value

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    Pinjarra, Australia
    MS-Off Ver
    2011
    Posts
    45

    Google Sheets - Copy down down @ times based on another cell value

    I am in the process of learning to drive Google Sheets, as I learned my Job Database file I have been developing will not work in Office 365 online or mobile devices due to VBA not being supported.

    I want to learn how to replicate what I have already created in Excel, sheet attached, in Google Sheets. Never used Google Sheets before and not familiar with GAS.

    The first item I would like to tackle is how to automatically copy down a range # of times based on a value in another cells. So in the Recurring Job Entry Sheet TEST!, copy range A6:X6 down number of times indicated in cell O2.

    Here is the code I am using in Excel.
    Sub CopyOccurrences()
    '
    ' Macro1 Macro
    '

    '
    Sheets("Recurring Job Entry Sheet TESTI").Select
    [A6:S6].Copy [A7].Resize([O1].Value2)

    End Sub

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Google Sheets - Copy down down @ times based on another cell value

    While it helps to have a few examples to get started, if you haven't used Javascript or GAS before, you should expect at least a 3 month learning curve.

    Anyway, for this particular operation,

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-24-2014
    Location
    Pinjarra, Australia
    MS-Off Ver
    2011
    Posts
    45

    Re: Google Sheets - Copy down down @ times based on another cell value

    Thank you

    I entered the script, but I get this message:

    Google hasn’t verified this app

    The app is requesting access to sensitive info in your Google Account. Until the developer (******@gmail.com) verifies this app with Google, you shouldn't use it.

    I clicked continue anyway and got this:
    Attachment 726619

  4. #4
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Google Sheets - Copy down down @ times based on another cell value

    Is that gmail address yours?

    If you meant to attach a screenshot, it didn't work.

    Anyway, the code works for me. Here are links to the Google Sheets workbook and to a screen capture of the steps I took to use the code I provided in that workbook.

  5. #5
    Registered User
    Join Date
    09-24-2014
    Location
    Pinjarra, Australia
    MS-Off Ver
    2011
    Posts
    45

    Re: Google Sheets - Copy down down @ times based on another cell value

    Thank you for the screen record. It worked.

    Last edited by mariannehislop; 04-04-2021 at 08:34 PM.

+ 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 - change cell color based on days past date in another cell
    By Coffey80 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-10-2021, 03:20 PM
  2. Google Sheets: Create an IF statement with a subtraction, multiple times. Display Result
    By mlinds1989 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 02-20-2021, 06:06 PM
  3. Replies: 5
    Last Post: 02-20-2021, 12:48 AM
  4. Google Sheets: How to count the number of times a certain value has been chosen
    By cwinhall in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-14-2021, 01:32 PM
  5. [SOLVED] Google Sheets Conditional Formatting based on another cell value
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-16-2020, 12:07 PM
  6. Google Sheets: Cell changes color based on current time
    By TimRodriguez in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-15-2020, 06:48 AM
  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