If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Worksheet Fomatting
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Conditional Worksheet Fomatting
Good idea, but I'd like to do this without having to apply a filter every
time. I will be sharing the file, and I want the other users to avoid taking extra steps. This is a file I will be updating and viewing frequently, and I'd like to see the data on a separate worksheet. Thank you "Dave Peterson" wrote: 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 |
#4
|
|||
|
|||
Conditional Worksheet Fomatting
Try Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm Marie wrote: Good idea, but I'd like to do this without having to apply a filter every time. I will be sharing the file, and I want the other users to avoid taking extra steps. This is a file I will be updating and viewing frequently, and I'd like to see the data on a separate worksheet. Thank you "Dave Peterson" wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|