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

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.

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...).

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?

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!

What happened when you transferred it to Google sheets?

I've updated your thread title.

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