Posted to microsoft.public.excel.misc

excellent

Posts: n/a

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

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I display data in different worksheet in excel	Hedgelayer2	Excel Discussion (Misc queries)	1	February 13th 06 03:34 AM
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
DATA FILTER ARROWS DISPLAY WHILE INACTIVE	lassie	Excel Worksheet Functions	0	August 3rd 05 02:41 PM
Macro to search for and display data in another worksheet	Mark H	Excel Worksheet Functions	0	June 14th 05 12:40 PM
Display selected rows from one worksheet to another	Brian	Excel Worksheet Functions	5	October 29th 04 12:26 PM

All times are GMT +1. The time now is 04:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us