Copy certain cell values from 1 sheet to other by filtering

P

ppminj

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy of value from one sheet to another with matching column values 1
Excel -- Cutting and Pasting Certain Values from a Column to another Sheet? 0
Put data by matching cell value with sheet name 2
Copy Data from 1 Sheet to Another 3
Copy values from a cell based on values of another cell 4
Find value from sheet 1 on sheet 2 and copy to an offset from there 3
how to compare two columns on two sheets and copy associated data from one sheet to the other? 1
Macro to Copy certain values from different sheets to TIME Sheet 4

Top