+ Reply to Thread
Results 1 to 2 of 2

Google Sheets - Insert new row and duplicate data if qty is more than 1

  1. #1
    Registered User
    Join Date
    01-25-2022
    Location
    Amsterdam
    MS-Off Ver
    Google Sheets
    Posts
    1

    Post Google Sheets - Insert new row and duplicate data if qty is more than 1

    Hello everyone,

    We make use of a mail merger in google sheets to create labels that we can use on our cards. I am looking for a macro solution that I can use to easily duplicate rows if an order row contains more than 1. All of our labels are sorted so if I duplicate a row number 12 needs to become something like 12,001 followed by 12,002 etc. the 3xFM also has to become 1xFM in 3 separate rows.

    I have no clue how macro's work so if anybody can hlep me out then that would be great!
    Attached Files Attached Files
    Last edited by CasparV; 01-26-2022 at 05:22 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Google Sheets - Insert new row and duplicate data if qty is more than 1

    This will be a macro using Google's code, I presume, so I'm moving this to the correct forum section for Google Sheets queries.
    Ali


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

    Forum Rules (updated August 2023): please read them here.

+ 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 Duplicate Nth Character and/or Vowel in a string.
    By antonyx in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-10-2022, 11:52 AM
  2. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  3. [SOLVED] Google Sheets:Formula for Duplicate Entries over multiple rows and ignoring blank columns.
    By ItsRay in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 9
    Last Post: 10-18-2021, 10:59 AM
  4. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  5. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  6. [SOLVED] Insert new line (within formula which is combining text) - GOOGLE SHEETS
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 05-12-2019, 05:55 PM
  7. 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

Tags for this Thread

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