Conditional Worksheet Fomatting
Instead of separating your data, how about selecting that column H and then
data|filter|autofilter
Use the dropdown to show only the YES's.
Data|Filter|show all
will make all the data appear.
Marie wrote:
I'd like a separate worksheet within a workbook to display desired results
only. For example:
All data is contained in Sheet1
Sheet2 displays only rows from Sheet1 where column H = 'yes', without
leaving a bunch of blank rows corresponding to undesireable results.
Thanks
--
Dave Peterson
|