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

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