엑셀에서 Alt+F11 에서 모듈 삽입후 아래 붙여 넣으시고 실행 하십시요.
Option Explicit
Public Sub extraftCol()
Dim range1 As Range
Dim newworkbook As Workbook
Dim newworksheet1 As Worksheet
Dim newworksheet2 As Worksheet
Dim rngTemp As Range
Dim intCol As Integer
Dim intRow As Integer
‘Set range1 = Range(“A:D, BI:BI,BQ:BQ”)
Set range1 = ActiveSheet.UsedRange
Set newworkbook = Workbooks.Add
Set newworksheet1 = newworkbook.Worksheets(1)
Set newworksheet2 = newworkbook.Worksheets(2)
Application.ScreenUpdating = False
For Each rngTemp In range1
If Not IsEmpty(rngTemp) Then
intCol = rngTemp.Column
intRow = rngTemp.Row
Select Case intCol
Case 1
newworksheet1.Cells(intRow, 1) = rngTemp
newworksheet2.Cells(intRow, 1) = rngTemp
Case 2
newworksheet1.Cells(intRow, 5) = rngTemp
newworksheet2.Cells(intRow, 7) = rngTemp
Case 3
newworksheet1.Cells(intRow, 4) = rngTemp
newworksheet2.Cells(intRow, 6) = rngTemp
Case 4
newworksheet1.Cells(intRow, 3) = rngTemp
newworksheet2.Cells(intRow, 4) = rngTemp
Case 61
newworksheet1.Cells(intRow, 2) = rngTemp
newworksheet2.Cells(intRow, 3) = rngTemp
Case 69
newworksheet1.Cells(intRow, 6) = rngTemp
newworksheet2.Cells(intRow, 9) = rngTemp
Case Else
End Select
End If
Next
Application.ScreenUpdating = True
End Sub