Thread: Macro maybe?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Macro maybe?

Format the column as Special/ ddd, filter, custom, equals Saturday or equals
Sunday, delete rows.

"Connie Martin" wrote:

In Col. A there are dates, formatted as dates in the format of Sun - Jan 01,
2010 and it goes to the end of 2010. How do I delete all the Saturday and
Sunday's in one shot? Connie