=IF(Sheet1!A1="Something I want it to be",Sheet1!A1,"")

Put this in A1 of sheet 2 and drag along the row. If the condition you set
evaluates as True then it will copy Sheet 1 A1 to Sheet 2 A1 etc.

"krishnan" wrote:

how to link the entire row of a work sheet to another work sheet based on
some condition. Any help

Regards
krishnan