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?
Bookmarks