+ Reply to Thread
Results 1 to 3 of 3

Google Sheets: Create a new Sheet on Each Row

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    36

    Google Sheets: Create a new Sheet on Each Row

    Hi All,

    I don`t know if this one is possible with Formula, Please let me know.

    Can anyone please help me out in this scenario? I am trying to add a sheet on each and every row, and as soon as any column update in that row, it should update the sheet as well.

    Below what i am trying to achieve:

    1. Whenever a new row added and the column CreateSheet has a value "True", it should create new sheet with the same "Header" (First ROW) of the sheet to each and every sheet and it should copy the row all columns to the new sheet with all the values
    example:

    Main Sheet:
    FirstName LastName PhoneNumber DOB State CreateSheet
    Abdullah Sikandar 111-111-1111 09/09/09 TX True
    AA BB 111-222-222 09/08/1980 TX True

    Sheet 1 created with the Name of Abdullah (because i want to name a field with ROW NAME)
    Values for Sheet Abdullah
    FirstName LastName PhoneNumber DOB State ID
    Abdullah Sikandar 111-111-1111 09/09/09 TX 189371

    Sheet2 created with the Name ofBB (because i want to name a field with ROW NAME)
    FirstName LastName PhoneNumber DOB State ID
    AA BB 111-222-222 09/08/1980 TX 548410


    2. As soon as any field updated in any one of the column on Main Sheet, it should update the column in the created Sheet.
    Example:

    If Phone number got updated in Main Sheet for Abdullah ROW then it should be updated in the sheet "Abdullah", Same thing if any column got updated in sheet "Abdullah", it should update the "Main Sheet" column as well.


    Let me know if you have any questions

    Thanks in Advance.

  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
    79,369

    Re: Create a new Sheet on Each Row

    Which version of Excel are you using?

    There are instructions at the top of the page explaining how to attach your sample workbook.
    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.

  3. #3
    Registered User
    Join Date
    02-06-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Create a new Sheet on Each Row

    Hi AliGW,

    Actually, I am using the ExcelSheet on Gmail so I am using Google sheet to implement this.

    Is it possible?

+ 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 Master Sheet that pulls in data from other sheets with the last edit date
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-19-2020, 12:04 PM
  2. Create dependent dynamic range in google sheets
    By frnzy in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-17-2019, 06:23 AM
  3. Create dependent dynamic range in google sheets
    By frnzy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-17-2019, 06:23 AM
  4. [SOLVED] Vlookup for another sheet in google sheets
    By turkanet in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-02-2018, 04:42 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. Google Sheets: How to pull data from Tabs in Excel to create a list
    By CR9596 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 08-09-2018, 11:53 AM
  7. Replies: 1
    Last Post: 01-25-2014, 02:10 PM

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