+ Reply to Thread
Results 1 to 3 of 3

Delete a specific row by matching 2 columns.

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Delete a specific row by matching 2 columns.

    Hi All,
    I want to delete a specific row in an excel sheet by matching 2 columns using a VBA excel macro. Col A and Col D has values like below. I want to delete the Entire Row 1- Taxation Non Finance. Any help is appreciated.

    Col A Col D
    1 Taxation Finance
    2 Civil
    3 Admin
    1 Taxation Non Finance
    1 Taxation Business

    Thanks

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Delete a specific row by matching 2 columns.

    can you show better ?

  3. #3
    Registered User
    Join Date
    07-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Delete a specific row by matching 2 columns.

    the excel sheet has couple of couple of columns, we need to search for specific values in 2 col's , Col A and Col D. Let's say we need to search the value 1 in Col A and the value "Taxation non Finance" in Col D. And once we get the row no, I want to delete the entire row using a VBA macro.
    Can this be possible by using "Find" rather than "Range" of excel.
    Hope this helps.

+ 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