Thanks a lot for the the help.One more help I need in this macro,Can you please sort the B column in Ascending order first then on the basis of Device name (B column) sort the the E column (date) in ascending order.

Note-In the starting of macro sort the column