I have done the first part ie. deletion part. The second part you said I m not clear with it. Pls can you explain it with an example?
Mean while you can check the deletion part...

POS2.xlsm