Copying Certain Rows to New Worksheet

I am having trouble copying Rows to a new worksheet for which the F column output is "TRUE".

To further elaborate I want rows with the value "TRUE" in the F column to copy and paste the whole row to a new Sheet while excluding the F column itself.

Attached is the worksheet to compliment the problem.

Appreciate someones help. Thank you

Thanks for a quick reply. Is there a way to do this without a macro?

Assuming you have same headers on sheet2, in A2 array enter (Ctrl+Shift+Enter)...

Formula:

Please Login or Register  to view this content.

...copy right, format as desired, then copy down.

Change the 100's to the extent of your data on sheet1 or a bit greater... but changing to whole column ($F:$F) will use additional and unnecessary processing.