Auto Copy/autofill Text from sheet to sheet if meets criteria
 

Hello! Using Excel 2007

I want to automatically take text from one worksheet and display it on a
different worksheet if it meets a text criteria. IE, if the DEPARTMENT
column value is "finance" - then display the whole row of data in the new
worksheet. If it does not meet this criterion - then return nothing (but I
do not want empty rows).

I appreciate any assistance! Thanks!