Select Unique Data use it create worksheet(s) populate correct sheet with correct data

Test.xlsx

So this is doing my head in and I'd appreciate any help...

On the attached sheet (test) is a list of people, with specific types of SIM cards, belonging to specific centres.

I would like to be able to select a list of the unique centre numbers, create worksheets within this work book with the corresponding Unique centre numbers.

One this is complete I would like to put the correct data from the raw data on the corresponding centre number sheets. As per Results.xlsx

Finally I would like to save each of the sheets as its own file.

Finally I would like to save each of the sheets as its own file.

Are you creating separate books, or worksheet? If you creating separate sheets(tabs), then you are not creating new book, i.e. new sheet will remain on the same workbook.

In the end I want to have seperate workbooks, however it isn't important if in the interim this information is transferred to new sheets or books.

This code creates sheets(tabs)on the same workbook

Please Login or Register  to view this content.

Thanks this is brilliant!