View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bishop Bishop is offline
external usenet poster
 
Posts: 208
Default Deleting rows that contain a certain value in column A

I have a spreadsheet sorted by column A. I need a procedure that will find
every cell with a specific value (they will all be grouped together because
of the sort) in column A and delete every row (ever how many it is) that has
that value in column A. Then I need the remaining data shifted up.