Need help scrubbing a spreadsheet

[PSpence]

Wondering if this is possible. I have a spreadsheet of 40k entries. Basically names and addresses of property owners. I would like to be able to search for a certain word (in this case "Heir") throughout the spreadsheet and be able to find every line containing that word and place it in a separate spreadsheet. Is this even possible? It would be awesome to be able to sort like this.

 

[kevin9999]

Further to what @johnnyL has asked for, do you already have a sheet where you want the data to be copied to - if so, what is it called - or do you want a new sheet added?

 

[kevin9999]

Wondering if this is possible. I have a spreadsheet of 40k entries. Basically names and addresses of property owners. I would like to be able to search for a certain word (in this case "Heir") throughout the spreadsheet and be able to find every line containing that word and place it in a separate spreadsheet. Is this even possible? It would be awesome to be able to sort like this.

Are you still looking for assistance with this, or have you found a solution?