I have got myself in to a bit of a Monday morning mess!
I have used a piece of code to do the following:
1.Read through a section of data (B17:M47)
2.IF "B" is NOT blank and "M" IS, copy it
3.Find first blank row in range (B17:M47) of new worksheet
It works well and is...