YUP..... it's those friggen merged cells !!!

In the first macro, in the copy data to scrathpad portion, in the line

lr = ws.Cells(Rows.Count, 1).End(xlUp).Row

Excel was not getting the last row of column1 (A), it's getting the top of the merged area. I change the 1 to 2 in order to use column B to find the last row and now it works for one of your IT sample sheet and not the LOG sheet, complains about can't change part of a merged cell, and that's even after adding 10 to lr.

Not sure what's required but I'm looking into it.

If another member has a solution for this, PLEASE help us out. Thanks.