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: 1
Default Need help please for deleting rows that does not meet several criteria


Hi All,

Can someone please help me if a macro function in excel can help delet
rows that does not meet several conditions.

Example:

For a range the macro will delete the row if it does not contain th
following characters

*ADT7461*
*REF19*
*AD623*
*AD8200*
*ADXL330*
*OP291*
*AD1555*
*AD5561*
*COLD*

the number of rows is up to 20,000 and if possible i can just assig
the conditions in a range in another worksheet so that if an additiona
condition is placed it will automatically be included.

I need the help of your excel guru gods please....

this is already beyond my excel know-ho

--
Ali
-----------------------------------------------------------------------
Alib's Profile: http://www.officehelp.in/member.php?userid=661
View this thread: http://www.officehelp.in/showthread.php?t=136770

Posted from - http://www.officehelp.i

 
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
Counting characters in multiple rows when rows meet specific criteria news.virginmedia.com Excel Worksheet Functions 3 June 28th 08 09:03 PM
Selecting Rows that meet criteria NoodNutt Excel Worksheet Functions 1 June 22nd 08 10:29 PM
count rows that meet certain criteria klp Excel Discussion (Misc queries) 3 August 28th 07 05:10 PM
Deleting/IDing Rows that Don't Meet Criteria LittleAndLost Excel Worksheet Functions 1 November 3rd 04 07:21 PM
Deleting/IDing Rows that Don't Meet Criteria LittleAndLost Excel Worksheet Functions 2 November 3rd 04 01:32 PM


All times are GMT +1. The time now is 11:27 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"