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.
I am attaching a test sample sheet.
Any help is greatly appreciated as I am new to macro or excel high end formulaes.
Thanks in advance.
Pawan
Bookmarks