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