Hey all,

I have three columns (A, B and C) each containing recurring data to a
point and then cahnging slightly, eg:

A B C
NY TOM 96
NY TOM 96
NY TOM 96
NY TOM ALL
SO BILL 10
SO BILL 10
SO BILL ALL
NC PETE 1
NC PETE ALL


How can I get it so excel will just search for the columns with 'ALL'
written in them and then copy whats in columns A and B onto a seperate
sheet. So instead of getting everyone and everything I'll just get


A B
NY TOM
SO BILL
NC PETE


Many thanks for any help or pointers.

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=480603

Hru48 Wrote:
Hey all,

I have three columns (A, B and C) each containing recurring data to a
point and then cahnging slightly, eg:

A B C
NY TOM 96
NY TOM 96
NY TOM 96
NY TOM ALL
SO BILL 10
SO BILL 10
SO BILL ALL
NC PETE 1
NC PETE ALL


How can I get it so excel will just search for the columns with 'ALL'
written in them and then copy whats in columns A and B onto a seperate
sheet. So instead of getting everyone and everything I'll just get


A B
NY TOM
SO BILL
NC PETE


Many thanks for any help or pointers.

Hayley

Hi Hayley

Try Data Filter Autofilter, click on the down arrow for column c and
select all, then copy and paste the data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480603