Hi, does anyone know the vba code to read the word "it" in column B, and once the code reads it, copy the cell to the right of it to another sheet?
Thank you
Hi, does anyone know the vba code to read the word "it" in column B, and once the code reads it, copy the cell to the right of it to another sheet?
Thank you
Maybe:
Sub jericho14444ZZZ() Dim rcell As Range Application.ScreenUpdating = False For Each rcell In Range("B2:B" & ActiveSheet.UsedRange.Rows.count + 1) If rcell.Value = "it" Then rcell.Offset(, 1).Copy Sheets("another sheet").Range("C" & Rows.count).End(3)(2) End If Next rcell Application.ScreenUpdating = True End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks