ç¨ä¸è½çvbaå¯ä»¥å®ç°ã举ä¾è¯´æã
ä¾å¦æä¸æ件ï¼å ¶ä¸sheet1ãsheet2ãsheet3ææ°æ®å¦å¾ï¼
ç°è¦æ±å°sheet1~sheet3çaåæååæ¾å°sheet4ä¸ãåå®å·²ç¥æ°æ®é¡¹çæ°éé½ç¸åä¸çäº5.
第ä¸æ¥ï¼æå ¥æ¨¡åï¼ç¼å¶ä»£ç å¦ä¸ï¼
Sub å建æ°è¡¨()
Const hs = 5
For i = 1 To hs
Sheet4.Cells(i, 1) = Sheet1.Cells(i, 1)
Sheet4.Cells(i, 2) = Sheet2.Cells(i, 1)
Sheet4.Cells(i, 3) = Sheet3.Cells(i, 1)
Next i
End Sub
第äºæ¥ï¼è¿è¡è¯¥å®ãç»æå¦å¾ï¼