Hi Holger,

That was really quick. You are brilliant. I tried it and it worked perfectly.
Can I request you again to provide me something for "if the sheet for deal id in Sheet1 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.". The reason being that even though I will get the data in Parts I receive consolidated data not just the new line items. I know the code will become heavy and too complex, But I would really like to see if it can be done.