Results 1 to 1 of 1

VB A to loop to search through a list and delete a record if found

Threaded View

4am VB A to loop to search... 07-25-2011, 10:26 AM
  1. 07-25-2011, 10:26 AM #1
    4am is offline
    Forum Contributor
    Join Date
    04-14-2008
    Location
    Fort Collins, Co
    MS-Off Ver
    2016
    Posts
    107

    VB A to loop to search through a list and delete a record if found

    I have two worksheets

    Sheet1 column A has a list of ID numbers
    Sheet2 Column L has that same ID number in it (somewhere)

    I want to find each record from Sheet1 in Sheet2
    If the record is found, I want to delete the entire ROW of that ID in Sheet 2
    If it is not found, I want to continue looping through.

    See attached workbook. Thanks!!

    Feel free to post back an XLSM if you want. I really appreciate the help!

    -Heather
    Attached Files Attached Files
    Last edited by 4am; 07-25-2011 at 10:33 AM.
    Is That Your Spreadsheet Or Did Your Database Just Throw Up?

    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1