search and delete rows

[matvoz]

Hello. I am new to VBA and need some assistance. I have a spreadsheet that has a column of week numbers (200801, 200802.....). I would like a macro that allows the user to input a starting week and an ending week and delete everything else. For example, when starting the macro a userform would pop up saying something like, "What is the starting week" and "what is the ending week". After entering that data it would delete everything that does not equal or fall within those weeks.

Any help is GREATLY appreciated.

Matt

[carddards]

Hi matvoz,

Give me a copy of your document so I can do it for you.