Results 1 to 4 of 4

Compare 2 columns delete rows with matching values

Threaded View

mattmac Compare 2 columns delete rows... 02-05-2009, 12:39 PM
Shijesh Kumar Re: Compare 2 columns delete... 02-05-2009, 01:31 PM
mattmac Re: Compare 2 columns delete... 02-05-2009, 01:46 PM
Shijesh Kumar Re: Compare 2 columns delete... 02-05-2009, 01:50 PM
  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    edinburgh, uk
    Posts
    46

    Compare 2 columns delete rows with matching values

    Hi Guys,
    Need a hand with something please.

    I've got two workbooks, Workbook1 with a list in column a and Workbook2 with a list in column F.

    I want to compare the cells in these columns and delete the entire row in Workbook2 if there is a match.

    Any ideas?

    Thanks in advance
    Last edited by mattmac; 02-09-2009 at 06:50 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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