|
BIG PROBLEM
Dear all,
see the following data : Location Part no. Qty. In-date A1 637A 1000 01-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C4 639A 2000 03-MAY-2004 C5 637A 500 11-MAY-2004 C10 807K 1000 03-MAY-2004 D1 639A 2000 04-MAY-2004 Above data is a simplified data for my question. Now, if I just want to show the data which the In-date is 03-may- 2004, and then the different part no will be distinguished by insert a row. Below is my wanted result. Location Part no. Qty. In-date C4 639A 2000 03-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C10 807K 1000 03-MAY-2004 |
BIG PROBLEM
Maybe autofilter?
-----Original Message----- Dear all, see the following data : Location Part no. Qty. In-date A1 637A 1000 01-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C4 639A 2000 03-MAY-2004 C5 637A 500 11-MAY-2004 C10 807K 1000 03-MAY-2004 D1 639A 2000 04-MAY-2004 Above data is a simplified data for my question. Now, if I just want to show the data which the In-date is 03-may- 2004, and then the different part no will be distinguished by insert a row. Below is my wanted result. Location Part no. Qty. In-date C4 639A 2000 03-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C10 807K 1000 03-MAY-2004 . |
| All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com