Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row between different item
Dear all,
Please see the following data: Part no. Loacation Date 637A A1 10-MAY-2004 807K B1 11-MAY-2004 639A B2 12-MAY-2004 807K C1 12-MAY-2004 807K D1 15-MAY-2004 How can I use macro or function to sort the data by part no. and then insert a row between each different part no automatically. Like the below result: Part no. Loacation Date 637A A1 10-MAY-2004 639A B2 12-MAY-2004 807K B1 11-MAY-2004 807K C1 12-MAY-2004 807K D1 15-MAY-2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert Item numbers | Excel Discussion (Misc queries) | |||
I can't insert a calculated item in a pivot table | Excel Discussion (Misc queries) | |||
automatically insert date when I scan an item | Excel Discussion (Misc queries) | |||
Removing a subtotal from an insert item in a pivot table | Excel Discussion (Misc queries) | |||
Why is the menu item "Insert - Name" greyed out? | Excel Discussion (Misc queries) |