§Ú¥Îif then§PÂ_¦¡«á¡AYsheet1²Å¦Xªº¸ê®Æ¡A«ü©wÄæ¯S©w¦C¦^¼g¨ìsheet2, ¦p¤U¡A¦ý³o¼Ë¬Ý¨Ó¦n¤£±M·~¡A¦³Â²¤Æªº¤è¦¡¶Ü
if then
sheets(2).Cells(K, 1) = sheets(1).Cells(i, 1).Value
sheets(2).Cells(K, 2) = sheets(1).Cells(i, 2).Value
sheets(2).Cells(K, 3) = sheets(1).Cells(i, 7).Value
sheets(2).Cells(K, 4) = sheets(1).Cells(i, j).Value
.............................
. |