heater

I have a sheet as below. Whenever there are 2 rows only that match in K then I want them removed to another sheet. This must be when there is one heater blower and one heater in column AF. So in this example below rows 2-4 and 5-7 will remain as there are 3 rows but the rest would be removed to...

Could someone point me in the direction of a function that once InStr finds a substring, the function returns the entire word? For example, fx_WholeWord("I went to the theater and someone must have turned on the heater", "heat") would return both "theater" and "heater" Thanks y'all.

Hello, I have received some fantastic help so far and I appreciate the lessons. I am trying to apply copy and pasting rows with code for my new application but no success yet. What I would like to do is copy the checked maintenance row from Sheet1 to the end of the table in Sheet2 then clear...