Thread: Macro to delete rows containing specific data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Slohcin Slohcin is offline
external usenet poster
  
Posts: 10
Default Macro to delete rows containing specific data
I have a spreadsheet with the following data in a column:

C100
C101
MTH1
MTH2
R1
R2
TP1
TP2

I wish to delete all rows that contain MTH or TP in that column.
A macro to do this would be great.
--
Thanks
Slohcin
Reply With QuoteReply With Quote