Hi Sarah
Maybe you like EasyFilter
Very easy with this add-in
http://www.rondebruin.nl/easyfilter.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Sarah" wrote in message ...
Hi there,
I have a document that I update regularly. Various rows have to be hidden at
the end of the process. These rows are different every day, numerous and not
contiguous. I thought I could put a specific word in the first cell of every
row, then find a way to get Excel to highlight all those rows, then hide them
all in one go, probably using a macro. I can't work out how to make the
content of a cell result in that row being highlighted from the row header.
Any thoughts??
Thanks!