+ Reply to Thread
Results 1 to 13 of 13

Google Sheets: Update slave/child sheets from Master/Parent sheet

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Google Sheets: Update slave/child sheets from Master/Parent sheet

    Good Morning,

    I am trying to create a schedule program for my stores. On the attached file there are 4 tabs (Master List, and then 3 tabs with my 3 store's schedule template). What I would like to do is to figure out if there is a formula that will look at the Master List tab and automatically bring in all the specific store's data in columns B:G to the appropriate schedule tabs based on the department code in Column A.

    My goal is to only update the Master List and as I do it will update the schedule automatically. So I can remove employees and add employees and it will update accordingly. I hope I explained this properly.

    If anyone can help me I would greatly appreciate it.

    Thank You in advance for any time spent on my post.

    Jason
    Attached Files Attached Files
    Last edited by AliGW; 01-29-2021 at 02:52 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Update slave/child sheets from Master/Parent sheet

    Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

    A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

    Since you are an infrequent user of this site, on this occasion, I have changed it for you.

    However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

    *Other search engines are available!!!

    Regards,

    Glenn.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Update slave/child sheets from Master/Parent sheet

    In c11, copied across and down:

    =IFERROR(INDEX('Master List'!B:B,AGGREGATE(15,6,ROW('Master List'!$A$2:$A$200)/('Master List'!$A$2:$A$200=$F$8),ROWS(C$11:C11))),"")

    reformat column C as date.

    In hte telephone number column, to remove annoying zeros where no match exists, modify to:

    =IFERROR(INDEX('Master List'!F:F,AGGREGATE(15,6,ROW('Master List'!$A$2:$A$200)/('Master List'!$A$2:$A$200=$F$8),ROWS(G$11:G11)))&"","")

    and copy down. repeat for the other sheets (only done for one...).
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Re: Update slave/child sheets from Master/Parent sheet

    Thank You for changing my thread title. The thread title you chose for my post is something I would never have come up with because I don't know what it means and I've never heard of it. Sorry for not following Rule 1. I really struggle with excel and never know how to properly describe my issue in the thread title. I will try do better in the future. Again, Thank You for changing it for me and Thank You for your feedback.

    Jason

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Update slave/child sheets from Master/Parent sheet

    Don't worry about it.. Just try not to use emotive language (urgent... help... important...) It might be for you... but it's NOT to us!! Just think Google... what would you have used there and you won't go far wrong.

    Anyhow. Is it what you wanted?

  6. #6
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Re: Update slave/child sheets from Master/Parent sheet

    Hi Glenn,

    I'm not sure if I should ask you this or not but I was wondering if that formula you wrote would work in Google Sheets...

    I love excel but I also want the schedule program I'm creating to be a shared document that multiple people can be working on at the same time.

    Just let me know

    Thank You again for all your help

    Jason

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Update slave/child sheets from Master/Parent sheet

    You can ask... asking is free. But you might not like the answer...

    I have absolutely no idea. I have never opened a Google sheet... I wouldnt even know where to go to find one!

  8. #8
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Re: Update slave/child sheets from Master/Parent sheet

    Thanks Glenn. I marked it as unsolved to see if anyone else has any different ways to achieve what I'm trying to do

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Update slave/child sheets from Master/Parent sheet

    What happened when you transferred it to Google sheets?

  10. #10
    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,416

    Re: Google Sheets: Update slave/child sheets from Master/Parent sheet

    I've updated your thread title.
    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.

  11. #11
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Re: Update slave/child sheets from Master/Parent sheet

    It didn't show me the data. It was just blank.

    In cell C11 on the sheet tab where you wrote the formula it shows this formula on Google Sheets:

    =ARRAY_CONSTRAIN(ARRAYFORMULA(IFERROR(INDEX('Master List'!B:B,AGGREGATE(15,6,ROW('Master List'!$A$2:$A$200)/('Master List'!$A$2:$A$200=$F$8),ROWS(C$11:C11))),"")), 1, 1)

  12. #12
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Google Sheets: Update slave/child sheets from Master/Parent sheet

    FWiW... it's not an array formula in Excel...

  13. #13
    Registered User
    Join Date
    01-28-2016
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    48

    Re: Google Sheets: Update slave/child sheets from Master/Parent sheet

    When I upload it I guess Google thinks it's an array formula

+ 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. VBA: Master sheet to control only basic structure of slave sheets
    By emmo1210 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2020, 08:53 AM
  2. Replies: 2
    Last Post: 08-03-2020, 07:28 AM
  3. update master excel sheets from child sheets
    By Big_Kev007 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-23-2020, 09:38 AM
  4. Replies: 2
    Last Post: 06-08-2017, 04:28 PM
  5. looking for a macro that copy data across to its slave sheets from master sheet
    By mickgibbons1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-08-2017, 06:21 PM
  6. Transferring data from master sheet to slave sheets
    By mickgibbons1 in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 12-18-2016, 03:28 PM
  7. Copy ranges of data from Master Sheet to Slave Sheets
    By mike.haley in forum Excel General
    Replies: 0
    Last Post: 01-23-2013, 12:51 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