Macro to delete rows not containing a specified value

Hi,

I am needing a macro that will delete entire rows (up to 3000 rows) not containing a specified value(i.e. "100") in Column C. Row 1 contains titles for the columns.I have tried this on my own, but I am having trouble. I have seen a few that when the macro is started it propts you to input the value that you want to not delete. Any help would be appreciated. Solved