Create workbooks and worksheets

I have data of 4 product categories (A,B,C,D) and code assigned to each item is preceding with category like 'A01', 'B02' .....

Prepare a tool to create different workbooks for each product category and different sheets for each product code in the workbook .
`
Under the macro , I have to let the user dynamically select the sales data file .
For each category , the macro should create different workbooks for eg. For category 'A' create a workbook 'A.xlsx'

and within each category workbook create separate sheets for each code .
And I have to include data corresponding to that particular product code .

I have attached a sample data for reference

Being new to VBA programming .... I require a little help on this


Thanks

Try

Please Login or Register  to view this content.

Thank you jindon for such a quick response
The above code works but I am not able to get different workbooks ...

Here is the full problem statement -

Prepare one tool to create different workbooks for each product category and
different sheets of each product code in the category workbook.
For eg: In the attached workbook, your data is distributed across 4 product
categories (‘A’,’B’,’C’ and ’D’) and code assigned to each item is preceding with
category like ‘A01’, ‘B02’, ‘C032’

Tasks I have to perform :

1. Create a new Macro Tool workbook in which you will be creating the
macro. Ensure that you create a button in this file for the user to execute
the desired macro
2. Under the macro, first let the user dynamically select the Sales data file.
3. For each category, the macro then should create different workbooks. For
eg: For category ‘A’ create a workbook ‘A.xlsx’ These workbooks should be
saved at the same location as the Macro Tool workbook that you are
creating.
4. Within each category workbook, create separate sheets for each A code
(like A01, A02, etc) These sheets should be named as per the code.
5. Within each of the worksheets, include data corresponding to that
particular product code
6. Ensure that at the end, except the Macro Tool workbook, all other
workbooks are closed.

Thanks again

The code should do exactly what you said above except the button.

Yes Got it ...
Thanks a lot !