I created the macro below:

Selection.AutoFilter Field:=72, Criteria1:="4"
Columns("BR:BW").Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
Range("G26").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("2%").Select
Range("K6").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Sheets("Sheet1").Select
Range("H26").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("2%").Select
Range("I6").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

Basically I want to create a repetitive loop to increase the "4" in the
first line by one each time to 5, 6, 7.... till 340. Each time it is
increased the K6 and I6 values would also increase by one to K7 I7, K8 I8,
etc. Any help on how to do this? thank you!