jaydee
04-06-2012, 07:34 PM
Hi,
My worksheet has several names repeated each month and it has a total of 240 columns even though there are less than 2 dozen names.
Is there anyway someone can help me write a code that prompts me for an input box asking for what name I want to see and hide all other columns starting after column J?
Output
http://img18.imageshack.us/img18/3613/outputd.jpg
My worksheet has several names repeated each month and it has a total of 240 columns even though there are less than 2 dozen names.
Is there anyway someone can help me write a code that prompts me for an input box asking for what name I want to see and hide all other columns starting after column J?
Output
http://img18.imageshack.us/img18/3613/outputd.jpg