Extract specific data from columns and creating seperate sheets for each one

[Tyso]

Hi
Attached is a Question file - format in which I receive it.
In this file, I must create a seperate sheet for each ProductCode (which is in colum B) link with Product Category (which is in Column D) and the sheet must also be renamed to reflect the ProductCode and Product Category - see attahment Solution file to see how the result must look like.
Any assistance to create a code that I can use to perform this task would be much appreciated.

[Philb1]

Oops, did you forget to upload the example files?

[Tyso]

Hi Philb1

I just edited the post to make it more clear - I rename the post to "extract data from 2 columns"

[kvsrinivasamurthy]

If you sort the data on Product code you will get result. No code is required.

[Tyso]

Hi kvsrinivasamurthy
Thank you for your reply.
The result for each ProductCode must appear on a seperate sheet link with the Product Category and the sheet must also be renamed by using the ProductCode and Product Category - see attached solution file for one ProductCode.