Would Like To Hide Row Based On Cell Contents

[maesoph]

Dear All:

I need to hide all of the rows in a spreadsheet (15,000 rows) that have a part number that does not start with M or K. I have found lots of simple macros that do something similar but usually not with any sort of textual evaluation. Any help please?

 

[jim may]

What Version of Excel are you running?

If xl2007 + then why not use an Auto-Filter, Selecting "Text-Filters" - and Begins With
K, or Begins with M

 

[maesoph]

Well, this is a little embarrasing. I am running Windows 7 and cannot find the Help-About to figure out which version of Excel I am running.

 

[jim may]

From inside your Excel goto Help - About

 

[jasonb75]

Well, this is a little embarrasing. I am running Windows 7 and cannot find the Help-About to figure out which version of Excel I am running.

Jim's suggestion should work then, Help - About was moved in excel 07.

Office button > excel options > resources > about.

 

[maesoph]

Got it. Jim's suggestion worked fine. THANKS!!!!!

 

[jim may]

Jason - Thanks for the Needed Correction on difference in 2003 and 2007; I had already forgotten that. Jim