Results 1 to 11 of 11

Delete rows in separate tabs if string in column A matches

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    18

    Delete rows in separate tabs if string in column A matches

    Hi,

    I have 2 tabs with data in it called hmwk1 and hmwk2. In column A of each tab there is an identifier string, eg 101. I need some code that will look for duplicate strings in column A in both of these tabs. If there are duplicate strings in hmwk1 and hmwk2 delete the corresponding rows in hmwk1 and retain only the first entry in hmwk2. The aim is to have only ONE row with the identifier string in these tabs at the end of the macro. Below is an example using 101 as the identifier string in column A.

    Hmwk1 Tab

    Column A
    101
    101

    Hmwk2 Tab

    101
    101

    Should result in both 101 rows in hmwk1 and the second row in hmwk2 being deleted.

    Hope this is clear.

    I'd like to be able to do the same process across three other tabs too called 1's, 2's and 3's. If there are multiple instances of the same identifier keep only 1 row in the highest tab, eg if 101 in column A appears twice in 1's, once in 2's and once in 3's delete all but the one in 3's.
    Last edited by bonsaitrees; 11-11-2012 at 12:48 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