cell comparison macro

[Tkurtz]

Hi all,

I have whole number values in columns A B C D E, going from rows 1 to 1000. I would like to compare columns D and E. I would like a text box that asks what number i'd like to search for. Lets just say the number I want to find is 31. I would like it to then look in D1 for number 31 and if it is there to see if its ALSO in E1. If it is, and they both have 31 id like to delete the entire row(Ax:Ex), then move to the next line and do the same thing. How would the code look for that?

Thanks

[alansidman]

Try this:

Please Login or Register  to view this content.

[Tkurtz]

Thank you for such a fast response, it worked great!

after doing that I thought of something else simple that would help me alot and I was wondering if there was a way to edit the code to do so.

I wanted to have an input box that asks me what number id like to search for in column E. Lets say I search for 35. Then also another box that asks for a number im searching for in column D. Wherever it finds 35 in column E, it then looks next to it in column D and sees if that has the other number, say 28.

so basically if it finds 35 in column E AND finds 28 in column D, it deletes the entire row (Ax:Ex). Does that make sense?

[alansidman]

Give this a try:

Please Login or Register  to view this content.