Alan, it is amazing, you really did a great job.
Thank you so much for working and time you spent for it I really appreciate this.
However these code are taking a long time when I run this macro on 5.5 lacs rows