create worksheets depending on cell values.

[amar05]

Hi experts,
I am working on an excel spreadsheet and I need a macro that can create worksheets depending on cell values.

i.e. In the attached workbook, I want to create sheets based on the type. Type 1 and 2 will be on different sheets and type 0 and 3 will be on the same sheet. The sheet name doesn't matter, I only need the macro to find out what type the article is and then paste the rows in a different sheet.
Fyi, I've created the sheets manually so that you have an idea of what the end result should look like.

Is such a thing possible to achieve?

Thanks,
Amar.

[watersev]

hi amar05, option, please check attachment, press "Run" button or run code "test"

[amar05]

Amazing! Exactly what I needed.

Can you possibly explain what this part of the code means?

Please Login or Register  to view this content.

Thanks.

[watersev]

it uses loop to get each array value that is used to autofilter data

[amar05]

Appreciate your help, watersev. Thanks a lot.