Delete rows except user defined criteria

[mimocat]

Hi All,

I’m in desperate need of some excel help :help …

I have spreadsheet with a bunch of data. I want to run a macro that will prompt the user for name of a month (ex. March). With that input it will look in column D and delete all other months except March. Now that’s just the easy bit….I also want to run it on another spreadsheet where I can specify which months to delete (not all, just some).

The coding for this is beyond me…..

If anyone can give me some help on this, it will be GREATLY appreciated =)

Thanks!

[GTO]

Greetings Mimocat and Welcome to the forum:)

Your question seems clear enough, but just so we don't take off wrong, could you post a workbook w/what you have so far? Fake some sample data if there's any company/private info, and please include any limiters (like: I only want to delete the row from column xx to column xx) if there are any limiters.

Mark

[mimocat]

hi GTO!

I have attached an example to my original post.