I have a 'master sheet' of names (column A), along with various job titles (Column B). I need to extract the names (which are in alphabetical order on the master) to separate sheets based on the job titles - some names have more than one job title beneath the first entry and in this case the column name is not shown in column A where this occurs - but could be added if required for referencing). The master sheet is some 350 rows long and I need the extracted information collated consecutively (i.e. no gaps) on another sheet.

On this new sheet, information will be entered in other columns (C,D,E,F) and will need to be picked up by the master sheet - Pretty sure I can do this using the sumifs() function as I will have two parameters to use as criteria.

I want to avoid using VB and suspect the answer is via an array using index/indirect/offset functions? Not sure how to do it so some help would be greatly appreciated.

Thanks