با سلام خدمت عزیزان بویژه استاد عزیز Iranweld
به لطف خدا و تلاش بی وقفه هرطور بود مشکل رو حل کردم خیلی ممنونم از راهنمایی های عالیتون ، مطمعنا" بدون کمک شما ، حل مسله نیازمند تلاش خیلی بیشتری می بود.
با تشکر
کد:
Sub transfer()
Sheets("A").Select
Range("C2").Select
Selection.End(xlDown).Select
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.End(xlDown).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorLight2
.TintAndShade = -0.249977111117893
.PatternTintAndShade = 0
End With
za1 = Sheet2.Cells(Sheet2.Rows.Count, "C").End(xlUp).Row
For I = 2 To za1
If Range("C" & I).Interior.ColorIndex = 49 Then
ActiveSheet.ListObjects("Table269").Range.AutoFilter Field:=3, Criteria1:=RGB _
(22, 54, 92), Operator:=xlFilterCellColor
Exit For
End If
Next I
Range("C2").Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.EntireRow.Delete
Sheets("B").Select
Range("B2").Select
Selection.End(xlDown).Select
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Selection.End(xlDown).Select
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
za1 = Sheet3.Cells(Sheet3.Rows.Count, "B").End(xlUp).Row
For I = 2 To za1
If Range("B" & I).Interior.ColorIndex = 3 Then
ActiveSheet.ListObjects("Table6").Range.AutoFilter Field:=2, Criteria1:=RGB _
(255, 0, 0), Operator:=xlFilterCellColor
Exit For
End If
Next I
Range("B2").Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.EntireRow.Delete
Sheets("HOME").Select
za = Sheets("A").Cells(Sheets("A").Rows.Count, "B").End(xlUp).Row
For I = 2 To za
If Sheets("A").Rows(I & ":" & I).EntireRow.Hidden = False Then
z2 = Sheets("Home").Cells(Sheets("Home").Rows.Count, "B").End(xlUp).Row + 1
Sheets("A").Range("B" & I & ":j" & I).Copy Destination:=Sheets("Home").Range("B" & z2)
Sheets("Home").Range("K" & z2) = 1
End If
Next
zb = Sheets("B").Cells(Sheets("B").Rows.Count, "B").End(xlUp).Row
For I = 2 To zb
If Sheets("B").Rows(I & ":" & I).EntireRow.Hidden = False Then
z2 = Sheets("Home").Cells(Sheets("Home").Rows.Count, "B").End(xlUp).Row + 1
Sheets("B").Range("B" & I & ":B" & I).Copy Destination:=Sheets("Home").Range("c" & z2)
Sheets("B").Range("D" & I & ":G" & I).Copy Destination:=Sheets("Home").Range("G" & z2)
Sheets("Home").Range("K" & z2) = 2
End If
Next
Sheets("A").Select
Range("A3").Select
ActiveSheet.ShowAllData
Sheets("B").Select
Range("A3").Select
ActiveSheet.ShowAllData
Sheets("HOME").Select
Range("A3").Select
End Sub
علاقه مندی ها (Bookmarks)