Thread: [Solved] Macro to conditionally delete rows
View Single Post
 
Old 08-22-2012, 12:22 AM
Steve_D Steve_D is offline Mac OS X Microsoft Office 2004 for Mac
Advanced Beginner
  
Join Date: Dec 2009
Posts: 59
Steve_D is on a distinguished road
Default Macro to conditionally delete rows
Hi
I'm a very basic Excel user. I have about 60 spreadsheets with up to 200 rows of information. Column H can contain one of two values: N or Y. I would like to delete all the rows that have an N in that column. Can anyone suggest a macro or similar to do that?
Thanks
Reply With Quote