either use the advanced filter functionality (off data menu, see help for how
to use it)
OR sort by column J, delete all rows where J is blank
(generally when I do a sorting/re-ordering macro, I'll add a column called
Order before sorting.. Order is simply a column numbered 1 - x designed to
maintain the original order)

"Bluenose" wrote:

Hi

I have 11 columns of data (A-K). Some of the cells in column J do not
contain data. I need to be able to strip out the rows in which there is no
data in row K and display them seperately on the worksheet or in another
worksheet.

Many thanks