Need help with a macro to filter data and paste it in the corresponding worksheet

Hello All,

I'm back the these very resoucefull forum, I've been looking for a macro that can sort a columm and paste the sorted data into its matching worksheet at the next available row, I've been trying to addapt a macro i found on othe forum but it mess up my sheets.

Ok, the file contain several worksheet, the first one is call All, using othe macro i was able to import all the data to this sheet, but having problem to filter it base on cell content in columm C and copy paste the filtered data in its corresponding worksheet.

Any help is highly appreciated,

Thank you in advance to the wonderfull people i had found in this form and for all thiers help
attached is the sample file

Alex

Maybe:

Please Login or Register  to view this content.

Dear Davis and AB33,

Thank you very much for your fast responses, I will test the macros tomorrow as soon I get to work, I really appreciate your time and wiliness in helping me with this matter.

Thank you again,

Alex

Ok,

I'm back with the result of the two approach, Davis whe i put the code on the actual book only copy one set of filtered data and paste it in all the worksheet, with some fixing it will do the job.

AB33, Your code is amazing, I had tried it on different workbooks and work perfectly. Now the the second part of the problem is that I also need to create a separated worksheet with the two main group of data on the sheet "ALL", I would call the group 1 and group 2.
I had applied filter and sort to the ALL sheet and columms F and G determined the separation of the two group, the F=YES should be pasted on group 1 and G=YEs on group 2, Could you kindly help me with this part.

I really appreciate the time you two had put on this matter.

Thank you in advance,

I had attached the new file

Alex

Try the attached.

HI AB33,

It can not be better than that, my respect to your expertise.
you save me a lot of time, just put it in a big load of data and wrok perfectly.

Thanks for your help.

I really appreaciate it.
Alex