Displaying Cells on a Different Worksheet based on Criteria

C

carl

I have a worksheet like so:

ColA ColB ColC
row1 Y June4 BOX1
row2 N June4 BOX3
row3 Y June4 BOX1
row4 Y June6 BOX2
row5 N June6 BOX1
row6 Y June6 BOX3

I would like to have a second worksheet to only display
the rows that have a "Y" in ColA. Sort of like this:

ColA ColB ColC
row1 Y June4 BOX1
row2 Y June4 BOX1
row3 Y June6 BOX2
row4 Y June6 BOX3


Thank you in advance !!
 
J

John Michl

Not sure of your requirements for using a second sheet. Here are two
approaches:
Option 1) Use only the first sheet and add a filter to the table (Data >
Filter > Autofilter). This would allow you to select "Y" from a drop down
list in the main table.

Option 2) If you must have a second sheet you could create a pivot table or
query that is linked to the first table. This would allow you to refresh
the second table anytime the original data may have changed.

- John
www.JohnMichl.com
 
C

carl

thanks. i do need the 2nd worksheet. the primary reason is
that the second sheet will have much less information than
the original sheet.

how would i create the pivot table and link it to the
original sheet ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top