Macro Help

Giganews Newsgroups
Subject: Macro Help
Posted by:  johnfli (jo…@here.com)
Date: Tue, 21 Oct 2003

I turn to you guru's for help with a macro question.

I have to worksheets in my workbook.

Both have a coulmn that has a 6 digit number in each cell (an invoice
number)

What I need to do is have a macro that starts with the first invoice # in
sheet 1, searches for it in sheet 2.
If it finds it, delete that row from Sheet 2.
Then it will look at the 2nd invoice number on sheet 1, Search from it in
Sheet 2
If it finds it, delete that row from Sheet 2.

etc, etc, etc

so, my question to you is.....

How?

Replies