Need VBA code for copy paste data to another worksheets

[Tarek_CTG]

Hello
How are you? I need a help for my workbook. In my attached workbook, there is a column named Remarks. In remarks, there are some comment such as "Joined", "Selection Under Process" etc. I want to run a macro after which all "Joined" data will go to "Joined" worksheet, all "Selection Under Process" will go to "Selection Under Process" worksheet etc. Can you please help me to find a vba code for this?

 

[JackDanIce]

If you're using a later version of Excel, which you appear to, this would be easier in Power Query, with less VBA and maintenance

Otherwise, record code as follows:
Make a copy of the Master sheet
Sort all rows by "Remarks" column
Create new sheets and copy the relevant Remark data across
Delete the copied sheet

Post the code back and readers can suggest improvements/changes

 

[Radoslaw Poprawski]

Power Query would be the best slution.
but for that to work out we would need minisheets or link to a file.

 

[Tarek_CTG]

how can I upload file here?

 

[JackDanIce]

Take a look through the forum guidelines and FAQs:

MrExcel Message Board FAQ

Welcome to the MrExcel Message Board!

www.mrexcel.com