Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete a row if strong NOT found....
I desperatly need a macro that will;
1. Ask me to input a column letter 2. Ask me to input a search string 3. Ask me to input a output file name 3. Search the entire column and delete all rows in which the search string is NOT found. 4. Save the results to the output file name *** The column rows will all have some other information than the search string *** such as "Earle Ike Toyota Volvo" I don't know if you need the following but here it is. I use excel 2002 - the worksheet contains no more than 15 columns but can have up to 25,000 rows. I work with automobile dealers and I have a worksheet with all dealership names, address and franchise names. I need to go into the info, delete all names that (lets say) do NOT have Toyota (search string) in them and then save the results to a new worksheet named Toyota but without changing (saving) the origional file. I can do the saving manually but it would be nice to have that in the macro also. I hope i covered it well enough to answer any questions. If not, my email is Thanks in advance for any help given. I really appreciate it. Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
IF NOT FOUND | Excel Worksheet Functions | |||
How to delete values of a cell if it is found in another coloumn | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |