Hi Guys.

I have a range or four columns filled with data. I need to copy only the rows which have a full set of data into a new sheet.
i.e. If on row 1 there was data in the first three colums but not in the fourth then that row would not be included.
But if on row 2 there was data in all four cells then that row would be copied to a new sheet.

The new sheet should be called DESPATCH NOTE.

Any ideas on how to do this?