Spreadsheet: 866793d1713713748-auto-filter-rows-to-hide-columns-with-zero-0-value-excel-forum-sample-sheet
Sheet: APRIL 2024 Inward Outward Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | APRIL 2024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | Size |  | Size-1 | Size-2 | Size-3 | Size-4 | Size-5 | Size-6 | Size-7 | Size-8 | [NAME] | Size-10 | Size-11 | Size-12 | Size-13 | Size-14 | Size-15 | Size-16 | Size-17 | Size-18 | Size-19 | Size-20 | Size-21 | Size-22 | Size-23 | Size-24 | Size-25 | Size-26 | Size-27 | Size-28 | Size-29 | Size-30 | Size-31 | Size-32 | Size-33 | Size-34 |  | GRAND TOTAL | #
 |  | Item |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | #
 |  | Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | #
 |  | UOM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | #
 |  | P.O. by |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | #
 |  | Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ` | #
 |  | P.O. Date |  | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty | PO Qty |  | PO Qty | #
 |  | B/F |  |  |  |  |  |  | 115 |  |  | 365 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | 27 |  |  |  |  |  | 36 |  |  |  |  |  | #
 |  | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  | 15
 |  | 2024-04-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  | #
 |  | 2024-04-16 00:00:00 |  |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-18 00:00:00 |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | Total P.O. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | Recd Date |  | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty | Recd. Qty |  | Recd. Qty | #
 |  | 2024-04-03 00:00:00 |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-06 00:00:00 |  |  |  |  |  |  | 75 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-11 00:00:00 |  |  |  |  |  |  |  |  |  | 150 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-12 00:00:00 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 14.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | 2024-04-16 00:00:00 |  |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  | 41 |  |  |  |  |  | #
 |  | 2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 11.5 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | Total Dely |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | ADJUST PO |  |  |  |  |  |  |  |  | 1.5 |  |  |  |  |  |  |  |  |  | -0.5 |  |  |  |  | 1 |  | -2 |  |  |  |  |  | 5 |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  | Balance Dely |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #