+ 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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,471

    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!

    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.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  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 Excel Formulas & Functions
    Replies: 0
    Last Post: 12-17-2019, 06:23 AM
  3. 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
  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