Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2012, 12:22 AM
Steve_D Steve_D is offline Macro to conditionally delete rows Mac OS X Macro to conditionally delete rows Microsoft Office 2004 for Mac
Advanced Beginner
Macro to conditionally delete rows
 
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
  #2  
Old 08-22-2012, 01:29 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Macro to conditionally delete rows Windows 7 32bit Macro to conditionally delete rows Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Steve,

If you're a very basic Excel user then it's probably better to avoid implementing your own macros for now. To do this manually you can add an autofilter to the sheet, filter column H by the value "N", select and delete the visible rows and then remove the autofilter. Once you've got the hang of doing that, it's a 5 second job.
Reply With Quote
  #3  
Old 08-24-2012, 09:37 PM
Steve_D Steve_D is offline Macro to conditionally delete rows Mac OS X Macro to conditionally delete rows Microsoft Office 2004 for Mac
Advanced Beginner
Macro to conditionally delete rows
 
Join Date: Dec 2009
Posts: 59
Steve_D is on a distinguished road
Default

Thanks Colin, that's a much simpler way to go.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to conditionally delete rows Macro to delete all empty rows from all tables braddgood Word VBA 15 10-02-2015 01:54 PM
Macro to conditionally delete rows Macro to delete rows with all empty cells ubns Excel Programming 2 08-14-2012 02:01 AM
Macro to conditionally create or go to worksheet Reinaldo123 Excel Programming 1 07-06-2012 07:23 AM
Macro to conditionally delete rows Macro Delete Selected Text smonczka Word VBA 2 11-05-2011 03:18 AM
Macro to conditionally delete rows Using macro to delete styles fogharty Word 1 10-10-2011 03:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft