Extract records to another worksheet

Originally Posted by thart21

New to Excel; I have large spreadsheet that has a column "Class". I need to break up the records based on "Class" and move them each to their own worksheet. For example, row one has a "Class" of "Vegetable" and row 2 is "Dairy". I want all the ones with "Vegetable" to be moved to one spreadsheet and "Dairy" to another. Is this possible?

I've seen advanced filtering but I still would have to copy/paste the data to different sheets.

Thanks for any help,

Toni

Please attach a sample file in zip format.