[ ίΔΜϋΦ | κ(ΕVXV) | SΆυ | ίO ]
@
wstep Μ@\π€άEΕ«Θ’xiͺΖj
`sheet1`
A B C@ 1 a 2 3 b 4 5 c 6
`sheet2`
A B C 1 a b c 2 3
’Βΰ¨’bΙΘΑΔ¨θά·B
ΔxΏβ΅½e΅ά΅½B
γLΜζ€ΘV[gͺ2 ιΖ΅ά·B
Α₯IΘΜͺAV[gPΙΝf[^ͺ1ZΙςρΕ’ιΖ’€±ΖΕ·B
±κπ{^π΅ΔAγLΜζ€ΙAV[g2ΙA·«άΘRs[΅½’Ζl¦Δ’ιΜΕ·ͺA€ά}Nͺ―άΉρB
ΘΊAR[hB
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
Sub {^1_Click()
Sub {^1_Click()
Set ws1 = Sheets("sheet1") Set ws2 = Sheets("sheet2") Dim i As Integer
For i = 1 To 1000 Step 1 ws2.Cells(2, i).Value = ws1.Cells(i, 1).Value
Next i
End Sub
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
m©ΙκρΪΝ’’ΜΕ·ͺA2ρΪΘ~Ν±ΜXebv{PͺΧ΅ΔAΐΫΝAV[g2Ι¨’ΔΰκΒΖΡΙΘΑΔ΅ά’ά·B
2ρΪΘ~ΜstepΜ{PπΕΏΑ΅ϋͺΗ€΅ΔΰΎίΕ΅½B
·’άΉρͺA²³φπ¨θ’’½΅ά·B
gp ExcelFExcel2019Agp OSFWindows10
Sheet1ΜsΤ 1 3 5 7 9 11 EEE Sheet2ΜρΤ 1 2 3 4 5 6 EEE
Όϋ©η1πψΖ
Sheet1ΜsΤ©η1ψ’½ 0 2 4 6 8 10 EEE Sheet2ΜρΤ©η1ψ’½ 0 1 2 3 4 6 EEE
K₯«ͺ©Β©θάΉρ©H
Sheet1ΜsΤSheet2ΜρΤ✕2-1
Ε·
iΠρΖj 2022/11/26(y) 01:41:04
ΟπP`ηΈΙg’ά΅ε€B
Sub {^1_Click() Dim ws1 As Worksheet, ws2 As Worksheet Dim i As Long, j As Long
Set ws1 = Sheets("sheet1") Set ws2 = Sheets("sheet2") For i = 1 To 1000 Step 2 j = j + 1 ws2.Cells(1, j).Value = ws1.Cells(i, 1).Value Next i End Sub
imFj 2022/11/26(y) 05:17:00
Sub test() Dim ws1 As Worksheet, ws2 As Worksheet Dim LastR As Long Set ws1 = Sheets("sheet1") Set ws2 = Sheets("sheet2") ws1.Rows(1).EntireRow.Insert 'tB^[Μ½ίΜ©o΅s}ό LastR = ws1.Cells(Rows.Count, 1).End(xlUp).Row With ws1.Range("A1") .Value = "©o΅" .Resize(LastR).AutoFilter 1, "<>" 'σΘOπo .CurrentRegion.Offset(1, 0).Resize(LastR - 1).Copy ws2.Range("A1").PasteSpecial xlPasteValues, Transpose:=True 'sρπόκΦ¦Δ\θt― .AutoFilter .EntireRow.Delete '©o΅sν End With End Sub itH[L[j 2022/11/26(y) 07:25:45
>ws1.Rows(1).EntireRow.Insert ws1.Rows(1).Insert ΙC³΅ΔΎ³’B itH[L[j 2022/11/26(y) 07:58:02
iͺΖj 2022/11/26(y) 08:42:39
[ κ(ΕVXV) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.