How do I Filter a column using a VBA script/commandbutton

[Franklienovice]

I am using Windows XP with Excel 2007, I am a complete novice to VBA and am trying to find a script that will help me to do the following
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have a large excel file that has multiply columns, and 1729 rows, I want to do the following,
Programme a commandbutton to unhide a sheet called “Info” then clear any filters they may be in place, then to go column “I” which contains lines
Similar to the below
<o> </o>
AMBER 187432
ANTICIPA 475482 <o></o>
ANTIPODES 077241 B<o></o>
APP UN 177174<o></o>
ARABELLA 1305 C<o></o>
ARABELLA 1305 L<o></o>
ARABIAN 133631 <o></o>
ARCTIC 190321
AZURA 201126
BELLA 141608
BIANCA 201362
<o> </o>
And filter it looking for all lines with say ie “APP 177174”
<o> </o>
Then I want to have another commandbutton that removes the filter , hides the sheet called “info” and returns to the original page ie “Front page”
thank you in advance for any help you can give me
Franklienovice

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=564776

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).