Hi Carl

I had a play and see there's merged cells everywhere & as soon as I saw that I stopped.
It's best to avoid merged cells like the plague, as merged cells & VBA don't get on very well.
The other thing is I think you've changed the layout of sheet 2, or at least enough for the VBA code to not work properly. If you can, settle on how you want it laid out & then do the coding. Coding doesn't compensate for any changes like cell formulas do.

The finding the row is done by looking straight up from cell E58 to the first row in column E that has something in it, the Offset(1,0) comes down 1 row from the row with something in. Hope that makes sense lol