Copy selected data to multiple worksheets when certain criteria in a row is met

I have attached a file called "Sample data"

In this file there are sheets " All Data, A, B, ..., to F"

What I would like is a macro to select from the "All data" sheet data with specific Class name to be copied into the the relevant sheet then follow on for all classes. Also to clear existing data in the sheets. The Classes are A, B, ..., F and are in column D of the "All Data" sheet.

Kindly note that different Classes have particular columns that are needed, for example:
A: only copy Name, Gender, Age, Class and Region
F: only copy Name, Class Region, Color, Height and Date joined.

HI
Try this code (not tested)

Please Login or Register  to view this content.

Thanks for your help. However, the code is not running. Please see attached spreadsheet.

Originally Posted by sintek

My take on this one...

Please Login or Register  to view this content.

Brilliant, to be honest I love it,well done
Best regards

Well done and thank you very much Sintek, it worked. I appreciate it!

Thank you Mohadin for giving this a go. You made it easier for me!