How to copy rows found by specific word in MS Excel?

Question

excel

Hello!
There is a large table with a list of goods: cabinets, chairs and tables.
Task: find everything by the word "table", select and copy to a new file.
How to do this and not run into unrelated ranges that the program does not allow to copy?
Maybe there is some formula?

Answer 1

You need to turn on the autofilter for the desired word, then select everything and copy it to a new sheet.