سلام
کد زیر رو در یک Module کپی و اجرا کنید!
چک کنید اطلاع بدید!
کد:
Sub hey_you()
Application.ScreenUpdating = False
Dim N As Integer
ActiveWorkbook.Sheets.Add after:=Sheets(Sheets.Count)
N = Sheets.Count
cnt = 1
For i = 2 To Sheets(1).Cells(Rows.Count, 1).End(xlUp).Row
For m = 3 To 14
If Application.WorksheetFunction.Count(Sheets(1).Range("C" & i & ":N" & i)) = 0 Then
Sheets(N).Range("A" & cnt).Value = Sheets(1).Cells(i, 1)
Sheets(N).Range("B" & cnt).Value = Sheets(1).Cells(i, 2)
cnt = cnt + 1
ElseIf Sheets(1).Cells(i, m) <> "" Then
Sheets(N).Range("A" & cnt).Value = Sheets(1).Cells(i, 1)
Sheets(N).Range("B" & cnt).Value = Sheets(1).Cells(i, 2)
Sheets(N).Range("C" & cnt).Value = Sheets(1).Cells(i, m)
Sheets(N).Range("D" & cnt).Value = Sheets(1).Cells(1, m)
cnt = cnt + 1
End If
Next m
Next
Application.ScreenUpdating = True
End Sub
علاقه مندی ها (Bookmarks)