Need help breaking master sheet into tabs

See my attached workbook and let me know if it is what you have in mind. It has 5 sheets, Master, A, B, C, D.

The Master sheet contains names with departments, and the departments in my example data are A, B, C and D (thus the sheet names).

The department sheets use the following ARRAY formula to pull the names from the Master sheet into each individual sheet:

Formula:

Please Login or Register  to view this content.

The only change is the department letter from sheet to sheet (highlighted in red in the formula.)

Remember, ARRAY formulas are applied by pressing CTRL + SHIFT + ENTER, not just ENTER.

- Moo

Glad to help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, feel free to click on the small star towards the bottom-left corner of one of my posts to 'Add to my Reputation' in the ExcelForum world. It's always appreciated!

Thanks,
Moo