Production Planning!

[Salford Steve]

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 stevekirby@glendalefoods.com if you feel you can help and I have added a copy of the spreadsheet if you need it for clarification.

Many thanks

Steve

[arthurbr]

You van attach a zipped example to a post

[mikev08826]

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

[Salford Steve]

Thanks Mike, that gets me part of the way there. Now just have to work out how I can get all three locations listed on one sheet ie

Loc 1 Loc 5 Loc 7
***** 324 ****** 10008 *** 2325



Steve