VBA: Create Arrays based on an Array

Hi guys

I have a question. I have an items list in Excel with different categories. Now I would like to create an array with all the different categories. Then I would like to create an array for each category to put in the items.

For example:

Item 1 - Cat 1
Item 2 - Cat 1
Item 3 - Cat 1
Item 4 - Cat 2
Item 5 - Cat 1

Now I read all the categories (Cat1, Cat 2, ...) in an array called arrCategories. After that I would like to dynamically create the arrays arrCat1, arrCat2.

Do you have an idea how to do that?

Thank you very much!

Regards
Lucas

Thanks so far. I'm just trying to get back into Excel scripting - this will take me some time.

Hi

I had to get warm again with VBA a little bit
My question didn't make too much sense.

But thank you!

I had a list, like a stock list, with several 100 items with unsorted categories. My goal was to create a new workbook and enter the stock list formated per category in order to send these lists to customers with some additional calculation fields etc.

My (easy) solution
1) Read through all the lines and store them in an array (e.g. arrStockList)
2) Read through the category field in the array arrStockList and create a dynamic array arrCategories
3) Loop through arrCategories, create a heading (etc.) for each category in the new workbook
4) Loop through arrStockList, add and format the item