IF and Else IF , Is there a better way to code this ?

You should attach a copy of your workbook. It is hard to optimise your code without seeing the data and testing the code to see what it currently does.