This is just and example. The actual sheet has columns till M
and approx 5000+ entries
I have records in sheet1
Code Item Qty price
1001 Pen 1 2
1002 Book 1 3
1003 Register 1 5
1004 Eraser 1 0.5
What I require is say may be in the same sheet or another sheet in any
one of the blank or un-used cell I just keep on entering the Code and give enter.
i.e for example if I give 1001 and enter the rest of the details in sheet1
i.e Pen , 1 , 2 should get deleted but not the Code number.
Now again I give 1004 and enter the details Eraser , 1 , 0.5 gets deleted
but not the Code 1004.
There will be a blank space in front of 1001 and 1004 after performing the
above operation which I can use anytime in the future to fill up new record.
I have tried various functions but unable to get the result.
reply
Bookmarks