Update slave/child sheets from Master/Parent sheet

[JGREEN17]

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

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ent-sheet.html