首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >比较两个列表并粘贴到新列表中

比较两个列表并粘贴到新列表中
EN

Stack Overflow用户
提问于 2018-10-11 07:49:57
回答 1查看 49关注 0票数 0

我有两个数据列表。列表A和B都包含字母等级。我想要比较数据,如果两个列表都有相同的字母,我想将该字母移动到列表C,该列表一开始是空白的。如果两个列表中没有相同的字母,请将字母保留在原来的位置。我想使用两个数组来存储数据,然后为新列表a、b和c创建三个新的数组。

代码语言:javascript
运行
复制
Sub example1()
Dim ListA As Range, ListB As Range, ListC As Range

    Range("H4:H10").Name = "ListA"
    Range("I4:I6").Name = "ListB"
    Range("J4", Range("J4").End(xlDown)).Name = "ListC"

Dim A(1 To 7), B(1 To 3), i As Integer, j As Integer

    For i = 1 To 7 'stores data in listA in array A
        A(i) = Range("ListA").Cells(i)
    Next
    For j = 1 To 3 'stores data in listB in array B
            B(j) = Range("ListB").Cells(j)
    Next

'select first from ListA and then compare data to listB
' if it is not found, stop and go to next item
'if it IS found, put in list C
Dim isfound As Boolean, letter As Variant, C(1 To 7), k As Integer

For i = 1 To 7
    isfound = False
        For j = 1 To 3
            If A(i) = B(j) Then
                isfound = True
                letter = A(i)
                Exit For
            End If
        Next
        For k = 1 To 7
        C(k) = Range("ListC").Cells(k) 'this is the part I am stuck on. How         
                                      do I get data to paste over to List C?
            If isfound = True Then
            C(k) = A(i) 'this says it will be equal to A(i) value if it is 
                         found.
            End If
        Next
Next
End Sub
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/52750255

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档