how do i filter data on one worksheet and display on another.

[Guest]

output conditioned on col2.

input :
sheet-1
col1 col2 col3
a1 a2 a3
b1 a2 b3
c1 c2 c3
d1 c2 d3

output :
sheet-2
col1 col2 col3
a1 a2 a3
b1 a2 b3

sheet-3
col1 col2 col3
c1 c2 c3
d1 c2 d3

 

[Dave Peterson]

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm