Production Planning!

Wonder if anyone can offer me a solution to this problem. To simplify I have a spreadsheet with 4 Columns: Product Code, Desc, Location No, and Total (this is a column calculated on a selected weekending date entered elsewhere)

I need to produce a separate sheet splitting into the 3 different locations in order to plan weeks production. However there are many items which will contain zeroes so I need to be able to automatically list only the ones with actual totals against them.

Any help would be gratefully received. You can mail me on [email protected] if you feel you can help and I have added a copy of the spreadsheet if you need it for clarification.

Many thanks

Steve

Autofilter the location then autofilter to include all totals but zero?