Sub copy() Dim rng As Range, ws As Worksheet Set ws = Workbooks("EXCELA.xlsx").Worksheets(1) For Each rng In Range(ws.[a1], ws.[a1].End(4)) If rng = [a1] Then rng.Offset(0, 1).copy [a65536].End(3).Offset(1, 0) If rng = [b1] Then rng.Offset(0, 1).copy [b65536].End(3).Offset(1, 0) If rng = [c1] Then rng.Offset(0, 1).copy [c65536].End(3).Offset(1, 0) Next End Sub 自己新建EXCELA和EXCELB两个表 数据要放Sheet1,自制以上代码到EXCELB表上运行即可
你可以在ExcelB的某个sheet页里面,按上图加一个button,然后点击这个button进去写下以下代码:for i=1 to SheetA.Range("a65533").End(xlUp).Row sheetB.cells(i,1)=sheetA.cells(i,1) sheetB.cells(i,2)=sheetA.cells(i,2) sheetB.cells(i,3)=sheetA.cells(i,3) next isheetA的1,2,3列对应你的q,a,b列;同理于sheetB.
Dim rng As Range, ws As Worksheet
Set ws = Workbooks("EXCELA.xlsx").Worksheets(1)
For Each rng In Range(ws.[a1], ws.[a1].End(4))
If rng = [a1] Then rng.Offset(0, 1).copy [a65536].End(3).Offset(1, 0)
If rng = [b1] Then rng.Offset(0, 1).copy [b65536].End(3).Offset(1, 0)
If rng = [c1] Then rng.Offset(0, 1).copy [c65536].End(3).Offset(1, 0)
Next
End Sub
自己新建EXCELA和EXCELB两个表 数据要放Sheet1,自制以上代码到EXCELB表上运行即可
你可以在ExcelB的某个sheet页里面,按上图加一个button,然后点击这个button进去写下以下代码:for i=1 to SheetA.Range("a65533").End(xlUp).Row
sheetB.cells(i,1)=sheetA.cells(i,1)
sheetB.cells(i,2)=sheetA.cells(i,2)
sheetB.cells(i,3)=sheetA.cells(i,3)
next isheetA的1,2,3列对应你的q,a,b列;同理于sheetB.