I need to capture rows of information from a worksheet, where the only
specific
identification in the row would be (say) a word "Hot".

I expect to have a quantity of rows of data (say) 20 rows, in one column
each row would say either "Cold", "Warm" or "Hot"

I would like to create a 2nd sheet that captures ONLY the "HOT" rows?

Is this possible? Can anyone point me to reference material or examples
please.

Thank you in advance for your time...

Kind Regards,

Brian

I am using MS Excel XP