Hello and thanks in advance to all those who attempt to assist and I will post a response on feedback to proposed solutions.
I have a large data set which consists of more than 200,000 rows. I am searching column R to see if has total in it. If it does, I select it and all the cells within that...