Copy certain cell values from 1 sheet to other by filtering

Joined
Jul 1, 2011
Messages
1
Reaction score
0
Hi,
I have list of columns for Names (Column 'A'), Numbers (Column 'B')
and Status (Column 'C') in Sheet 1.
I need to filter the Numbers based on value on Column 'C' which is the
Status column. As soon as the value in Column 'C' becomes equal to
'SEND SMS', excel should copy the corresponding Numbers (from Coulmn
'B') and Names (from Column 'A') from Sheet 1 and put in Sheet 2. The
values in Sheet 1 should be copied only and not moved.
I can do the same by filtering the Status Column 'C' by value 'SEND
SMS' and copy the result in Sheet 2 manually, but I want this to
automated by macro or some existing excel funtionality, since I will
be working with lot of data.
This may look like this

(Sheet 1)
Name Number Status
Sando 123 SEND SMS
JMJ Province 125
M Clarette A.C. 127
Rubanandan A 129 SEND SMS
Philomena 131
Cluny Nivas 133
Ruby 135 SEND SMS
Theresa 137
C T 139

Now Sheet 2 should look like

Name Number Status
Sando 123 SEND SMS
Rubanandan A 129 SEND SMS
Ruby 135 SEND SMS


Any help is greatly appreciated as I am new to macro or excel high end
formulaes.
Thanks in advance.
Pawan
 
Back
Top