Macro to search multiple Documents and delete Rows.

**BigSlick** · 10-17-2008, 11:13 AM

Let me preface this with the fact that I truly do not understand creating a Macro, give me some HTML, PHP, or a few other things and I'm good but I have never even attempted to create a Macro. That being said...

So, I'm going crazy and I figured this might be a good place to get some help so here goes. I'm trying to create an Excel Macro that will pull a list of numbers, then search my spreadsheet and if any of the numbers are found delete the entire row. I have been doing this manually but it's extremely tedious and I have to search through multiple spreadsheets each day. Anyone here know enough about Excel and Macros to be able to help me out?

Oh yeah, I have cross posted this at tizag.com but this is more for web design than Excel help so I posted it here as well.
http://forums.tizag.com/showthread.php?t=9650

**mhuston** · 10-20-2008, 11:53 AM

What do you mean by "pull a list of numbers?" Do you want Excel to go to some data source and get numbers? What is the source and how are the numbers formatted so Ecel can pull them? Or is the source a csv file?

And what row is to be deleted? The row where a certain number is contained? What about subsequent rows containing the same number?

**BigSlick** · 10-21-2008, 08:30 AM

Originally Posted by mhuston

What do you mean by "pull a list of numbers?" Do you want Excel to go to some data source and get numbers? What is the source and how are the numbers formatted so Ecel can pull them? Or is the source a csv file?

And what row is to be deleted? The row where a certain number is contained? What about subsequent rows containing the same number?

This is a manually updated list of numbers that will be pulled from a separate excel spreadsheet.

The row to be deleted will be any row that contains any of the numbers. I'm just not even sure where to begin with this thing.

**davesexcel** · 10-21-2008, 08:35 AM

Hi,
Check out this thread and example provided
http://www.excelforum.com/excel-prog...-into-one.html

**mhuston** · 10-21-2008, 09:10 AM

This should do it. I often use Ron deBruin's website, http://www.rondebruin.nl/tips.htm, for code. This is an edited version of examples of deleting portions of a worksheet (in this case "data") based on certain criteria, in this case values on a "criteria" worksheet in columnA. It runs as a macro, Delete_with_Autofilter_More_Criteria.