Hello! I have a spreadsheet with multiple tabs, and need to copy data from one tab to other tabs, depending on key words in column K. I have the code below that works for one, but need to know how to change it from one to multiple different search criteria and copying to multiple tabs. This copies anything with "Mazak" in column K to the Mazak tab. There are other tabs, Lathe, SL30, Fadal, etc. How can i change the script to search for each of those and copy rows to the correlating tabs? Thanks in advance!!


Sub CopyRow()
Application.ScreenUpdating = False
Dim LastRow As Long
LastRow = Sheets("Pop").Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Dim x As Long
x = 3
Dim rng As Range
For Each rng In Sheets("Pop").Range("K3:K" & LastRow)
If rng = "Mazak" Then
rng.EntireRow.Copy
Sheets("Mazak").Cells(x, 1).PasteSpecial xlPasteValues
x = x + 1
End If
Next rng
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub