Displaying Cells on a Different Worksheet based on Criteria

[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 !!

 

[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

 

[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 ?

 

[Ron de Bruin]

Try this example macro
http://www.rondebruin.nl/copy5.htm