Auto filter from a cell
 

I want to create an autofilter that will bring up the records by Factory. I
would like to write a macro to look at cell c6, then the user will type in a
factory and after hitting enter the macro would run, showing the filtered
records only. Can someone please help.