+ Reply to Thread
Results 1 to 2 of 2

VBA- Match two lists

Hybrid View

Remotruker VBA- Match two lists 03-19-2012, 05:33 PM
p24leclerc Re: VBA- Match two lists 03-23-2012, 05:31 PM
  1. #1
    Registered User
    Join Date
    03-02-2006
    Location
    USA
    MS-Off Ver
    O365 PC, Version 2207, 64bit
    Posts
    66

    VBA- Match two lists

    Goal-
    Make the two lists match while preserving comments on 'Updated'

    Given:
    Sheet 'Data' contains an updated list of items and associated data
    Sheet 'Updated' contains previous list of data which may or may not match 'Data'

    Each Product has a unique identifier (ex Item 1) to use for look up.

    Example: Item 1 is on 'Data' but not on 'Updated'
    If Item exists on 'Data', but not on 'Updated', Copy A1:I1 to 'Updated' to next open cell on column A:I.

    If Item exists on 'Updated' but not on 'Data', Delete entire row


    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: VBA- Match two lists

    What is the need of doing this. At the end, you'll end up with 2 identical lists being identical to Data. I would understand if you wanted a report on New Items or DELETED items. But you are only modifying the Updated list to be the same as the Data one. Or there is something I did not understand.

+ 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