Thread: sort and delete
View Single Post
  #1   Report Post  
SMILE
 
Posts: n/a
Default sort and delete


Hi everyone
Someone please helpme......
I have an excel file with some data and the column "K" is to enter the
date of payment.
I want the data to be sorted by column "K" and delete the rows if it
has a data in column "K"

This is to find out the rows with no date in "K"

I need a macro to run

Thanks in Advance
Toms


--
SMILE
------------------------------------------------------------------------
SMILE's Profile: http://www.excelforum.com/member.php...fo&userid=4880
View this thread: http://www.excelforum.com/showthread...hreadid=390143