LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 138
Default Selecting Rows based off certain criteria and deleting all others

Hi all,

I have a large population of data that needs to be sorted by certain
criteria, and I'm not all too great with macros, so if anyone could please
assist, that'd be great.

All I need to do for right now is remove all the rows that have no
highlighting in any of the columns. I've already gone through and
auto-filtered certain values that need to be analyzed, but there are
thousands of rows that didn't meet any of the criteria, so I'd like to remove
them. Is there a simple macro I can run that will search all 7 columns of
each row, and if none of them are highlighted, they will be deleted?

Thanks,

Jonathan

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows based on multiple criteria [email protected] Excel Programming 0 January 11th 07 07:40 PM
Selecting rows based on criteria JCP Excel Discussion (Misc queries) 3 April 5th 06 09:26 AM
Selecting rows based simultaneously on 3 criteria miserere Excel Programming 4 September 21st 05 07:33 PM
Deleting rows based on cell criteria jgranda Excel Programming 1 April 27th 04 06:41 PM
Deleting rows based on criteria John Walker[_2_] Excel Programming 2 December 12th 03 08:37 PM


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"