Copy a row into a new worksheet if a condition is TRUE

[ronbo5]

I have a personnel report that is generated monthly and I've got a formula that compares to the previous report,and if there is any NEW data it says "TRUE". When a row has "True" in column K, I want to copy the entire row into a new worksheet. and repeat that until all rows that contain true are in the worksheet. That way I'll have a report of only the new data.
I can easily use the filter, but I need it in a new worksheet rather than just having the filter. I'm still terrible at VBA, so any help would be appreciated. I looked for a similar thread and did not find one.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.