Avoid column

[sanju]

i am already finished my work but problem is we did not required additional column as shown in excel sheet so please compress code.
Sorry for my bad english

 

[Chihiro]

Cross posted:
https://www.excelforum.com/excel-programming-vba-macros/1186665-compress-vba-code.html

Please read below.
http://chandoo.org/forum/threads/new-users-please-read.294/

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

As for your question, it is unclear what you need as end result.

 

[vletm]

sanju
... someway clear,
but ... why double codes / CS No.
So, I tried to clean and take some typos away.
One possible ... or only You know what would be the result!