Hi

Attach the workbooks with expected results. May be we can provide VBA code to do the trick.