Sorted copy data in new worksheets

[ccsmith]

I should create Macro therefore I need your kind support.
I attach a sample file for better understand.
There is a DATA worksheet.
The macro main aim is:
according to the values of the column E (defB) need to copy the data by types in different sheets.
example: all data with letter "A" has to copy to worksheet SH1 and sort them by column F and H.
all data with letter "B" has to copy to worksheet SH2 and sort them by column F and H.
as many different letters are in the column B that should copy to as many sheets.
Gratis is that it could sort the data by worksheets based on column F and H.
I appreciate your any effort in advance.

[misrasomendra]

Hi,

Try below code:

Please Login or Register  to view this content.

[JBeaucaire]

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.



I've installed it into your workbook, moved the data to row1, then added the sorting.

[ccsmith]

misrasomendra:
It is marvellous. Your prompt solution is a great salvation for me.
Could I ask for an extra option?
Could you add the function to clear the content before the copy just from Range("C3:H" & lr) from every sheets except DATA?
Other cells will contain additional data.

[ccsmith]

JBeaucaire : your solution is brilliant.
But I need to copy just Range("C3:H" & lr) from DATA to the new sheets in a different range like A1 because other rows and columns contain formats and other data.
Could you modify your code according to this info?

[misrasomendra]

Hi,

Try Below Code:

Please Login or Register  to view this content.

And if this solved your problem than please mark the thread as SOLVED and if you feel the solution had helped you than do consider giving some reps by clicking the star of Add reputation below our comments.