Macro to Filter Table Based on Contents of a Cell which is Text

Hi -

I am trying to develop a macro so that will sort data based on the text found in a cell. So, for example in the attached workbook, I am looking for a macro that would filter the table, displaying only those rows in which the text in column J (PHU) is the same as the text in say, cell A1.

Thus, if I typed in "Levuma CHP", and then ran the macro, the table would only show rows with "Levuma CHP" in column J.

Does this make sense?



PM2A Beneficiary Data _Excel Forum_3-18-2013.xlsx

Does this help?
http://www.ozgrid.com/forum/showthread.php?t=14061

See the attached