How to create a macro that will delete all rows NOT containing specified numbers

[elmaco12]

Hello,
This is my first post on this forum, so I would just like to say hi to everyone!

What I need some help with is to create a macro that will seek through a specified column, looking for a couple of specified values. If a cell i that column does not contain any of the specified values, the macro should delete the whole row.

It would be awsome if it was possible to create an InputBox wich asks the user what column to look in and for wich values to look for.

(i have managed to create a macro that works for only one value, but not for multiply. I have about 36 values to enter)



Thanks for your time!

/M