Hi Holger,

Sorry to bring this up late, I need a little extra bit.
I may have to run the code again and again as data comes to me in bits and parts. So what I need is when i add data to sheet 1, if the sheet for deal id already exists it should skip to next line , such that it will move to additional data in sheet1 when i run the macro 2nd or 3rd time.

Thanks a Ton. The modification worked perfectly.