Is there a way that I can have Excel automatically export only certain rows
of data and then save this data as a new spreadsheet? Here's an example:

Company_ID Job_ID Job_Title
Job_Category
374 9031 Physical Therapist
0
374 7824P Orthopedic Surgery
Surgery
374 LT 3004 Family Practice
Family Practice
374 7769 Intensive Care
0

In the example above, the 4th column has two fields with a value of zero.
What I would like to do is have a way to export only rows that DO NOT have a
value of zero and then have this saved as a new Excel file. Doable?

If so, please explain in painful detail as I'm pretty much a novice with
Excel.

Thanks for your help and tips.