Delete rows in all worksheets where column A equals string

Hello,

I am in need of a macro that searches all worksheets for a value in column A and subsequently deletes the corresponding row.

Example:
I have a worksheet that combines all yearly data and sorts according to company name (column A)

Please Login or Register  to view this content.

I manually look for company names that do not have data in column C for at least 4 years (column B). Then, I want to be able to search for "AINO NV" and have these rows deleted in both the combined worksheet (above) and the worksheets for 2000, 2001, 2002 and 2003. Again, these worksheets are all within 1 xls file.

I have never worked with macro's before, so any help is greatly appreciated.

I have attached a sample workbook.
I can manually see in the aggregate worksheet that company A does not have EBITDA data for at least 4 years.
I would then like to be able to run a macro that deletes all entries on company A (entered in an inputbox) from both the aggregate worksheet and the yearly worksheets.

Right now, I have this:

Please Login or Register  to view this content.

Is this correct?

Did not see your reply, Blane, will try as well.

Originally Posted by blane245

here ya go. Note that I used UCase to not insist on case matching in the compnay name.

Please Login or Register  to view this content.

Hello,
I have been trying your code. I works fine on the sample project. On the real project it stalls on the following line:

Please Login or Register  to view this content.

It returns a run-time error 1004 application-defined or object-defined error
The real project has up to 1500 rows, could that be the problem?