Excel help please (show rows containing certain info)

Soldato
Joined
26 Apr 2004
Posts
6,165
Location
Wrexham
Hi, I have a list of rows (about 60 at the moment, but is growing quickly!) which contain some information I would like to filter (but not using the Autofilter) by Column A.

If possible, I would like to be able to type a value into a field, which the sheet would then be filtered by (apart from the top 2 rows).

Reason I dont want to use autofilter is that I would like to be able to save this as mht or htm once finished, and the autofilter does not show this.

Any ideas? Am i just being daft?
 
Back
Top Bottom