Move Data From one work book to another with Criteria

Hi,

I am stuck in one of my projects and I have no clue to work around this. I have a report with 50000 rows of data with 21 columns.

I want to move data based on certain code words I created in column D For EG: RS, RA, PE, RO and So on.

The data should be moved from Data Raw file to Data sorted File but based on the Code I have created sheets so which means RS from DATA raw should go to RS sheet in DATA sorted, the same should happen for all the other codes.

Any help appreciated i tried tweaking a macro for one of project but due to the large data the file hangs the whole day.

Hi !

Use a filter or an advanced filter, see the many samples in threads of this forum …

HI,

I have already tried it but what I am trying to achieve is get all Code names RS to a diff workbook named RS and all RA to a diff workbook with a sheet named RA. I have a total of 22 codes moving to 22 sheets.