Forum Discussion
Finding Text and Copying Row to Another Sheet
Hi there, I am attempting to use VBA to: Find Text String "CLOCKIFY" or "DROPBOX" in the source sheet called "Expenses-2022" tab/sheet under the "D" column and Copy the rows that contain either on...
If InStr(1, sourceSheet.Cells(i, 4).Value, "CLOCKIFY", vbTextCompare) > 0 Then
If you want to search in column D you can change the above line of code to 4 for column D. The change is highlighted in red.
OliverScheurich Thank you! I will give that a try.