I have two excel worksheets which have data cells. I want that if a cell in column J equals a certain value, let's saying "Negotiating", then it automatically pulls that row to a new worksheet.
The idea being that I can see a list of the most relevant rows I need from across all my worksheets.