Hi
DataFilterAutofilteruse the dropdown on the column containing the
"data of interest" and select the value you want to see.
--
Regards
Roger Govier
"Agent Wild"
wrote in message
...
Hi,
I have a sheet whereby every couple of thousand rows there's a row of
significant interest (there's a value in a column). How can I
automatically select these rows or hide the other rows so that I can
show only the 'interesting' rows?
Thanks in advance
--
Agent Wild
------------------------------------------------------------------------
Agent Wild's Profile:
http://www.excelforum.com/member.php...o&userid=35163
View this thread:
http://www.excelforum.com/showthread...hreadid=549398