Macro to strip out certain rows
 

Hi
Sorry if this is a simple macro but i am new to them.
I have 11 columns of data (A-K). Certain rows have no data in the cells of
column J. I need a macro to identify and strip out these rows and display
them somewhere else on the worksheet, or in a new worksheet.

Thanks for the help.

Macro to strip out certain rows
 

Filter than column (DataFilter<Autofilte), select blanks, then cut the
visible rows and paste them elsewhere.

--
HTH

Bob Phillips

"Bluenose" wrote in message
...
Hi
Sorry if this is a simple macro but i am new to them.
I have 11 columns of data (A-K). Certain rows have no data in the cells of
column J. I need a macro to identify and strip out these rows and display
them somewhere else on the worksheet, or in a new worksheet.

Thanks for the help.