+ Reply to Thread
Results 1 to 2 of 2

Copy certain cell value in column from one sheet to other based on filtering or match

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copy certain cell value in column from one sheet to other based on filtering or match

    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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Copy certain cell value in column from one sheet to other based on filtering or m

    Hello Pawan,

    See the attached. Hope this helps.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1