I have 2 workbooks, say workbook1 and workbook2 for example. workbook2 is blank, workbook1 has all of my information.

I need workbook1 to have the information on sheet1 to be copied onto sheet 1 of workbook2.

Say workbook1 has sheet1 with the following information, i ONLY want the information that does NOT have an X in column C to copy over to the other workbook.
So it should search each row and if there is NOT an X in column C it should copy the row to the other workbook.
COLUMN
A B C
APPLES 500 X
ORANGES 400
GRAPESN 550 X
LEMONS 480 X
LIMES 558


Thanks for all the help!!!