Is it possible to autofilter a list using the contents of a particular cell?
I have a list of rows that all have a Code Number. There may be 0 to 55 rows
that correspond to the Code Number. I need a way that will automatically
just display the rows matching the Code Number. I have several users and
none of whom that will take the time to learn how to autofilter. I think I
need an autofilter to filter based on the contents of a particular cell. The
contents of cell C5 is a unique Code Number, say JB007. I need the
autofilter to list only the rows, from a list that is 750 rows, to display
only the records that match this unique code. Is this possible? If so
please let me know how? Thanks for any assistance you can provide!