2桁ありですか・・とほほ
Sub 列コピー()
Dim wsFm As Worksheet
Dim wsTo As Worksheet
Dim srcRange As Range
Dim colListFm As Variant
Dim colListTo As Variant
Dim i As Long
Set wsFm = Sheets("㋐")
Set wsTo = Sheets("㋑")
Set srcRange = wsFm.Range("A1", wsFm.Cells(Rows.Count, "A").End(xlUp))
If wsFm.FilterMode = True Then
wsFm.ShowAllData
End If
srcRange.AutoFilter 1, Array("いちご", "みかん"), xlFilterValues
If WorksheetFunction.Subtotal(3, wsFm.Range("A:A")) > 1 Then
colListFm = Split("A,E,G,H,I,AN", ",")
colListTo = Split("A,J,C,D,E,AT", ",")
For i = 0 To UBound(colListFm)
srcRange.Offset(1).Columns(colListFm(i)).Copy _
Destination:=wsTo.Cells(2, colListTo(i))
Next i
End If
End Sub