Sort Data based on Criteria and CopyPaste to another worksheet

Hi there,

I am having trouble sorting data based on a cell value and then copying that data to another worksheet. I have a list of information on Sheet1 that needs to be transferred to another worksheet. However, the only data I wish to have transferred is the data in the row with the value TRUE in Column U. I need this to copy to the next blank row on Sheet2. Both Sheet1 and Sheet2 have headers. I have attached a simplified version of my workbook. Any help is greatly appreciated. The end goal of this list is to create an archive.

This will only do it for the first 500 rows if you do it for all it takes a wile to run

Please Login or Register  to view this content.

Try the attached.

Thank you both so much for the help. AB33 I ended up using your code it works perfectly!!