Hi Marvin,
Thanks you very much for helping me out. I have attached a sample data which shows the input data in sheet one and output in sheet 2. I tried the macro but I might be doing something wrong.
could you please have a look at it thanks a lot.
Bookmarks