Results 1 to 2 of 2

Delete rows based on Column B Values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    243

    Delete rows based on Column B Values

    Hi

    I am looking for a macro to delete the entire rows if cells in column B are DC, DTCF, FAS

    Column A
    Cost Center Digits
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22

    Column B
    CoCd
    USA
    USA
    USA
    SVCS
    ATR
    ATR
    DC
    TAX
    DC
    DC
    DTCF
    DC
    DC
    DC
    ATR
    FAS
    FAS
    TAX
    SVCS
    DC
    DC
    DC



    Please help.

    Regards,
    Vijay
    Last edited by vijanand1279; 01-20-2011 at 02:57 PM.

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