Copying Data from Sheet1 to sheet2 based on criteria for copy

Hi

I am new member on this forum. Excuse me if I have presented my query in a different way.

I have created a excel file it has number of columns on sheet1 in which some columns are shown below

DRAWING NO. Spool No. Joint No SIZE Size WELDER ID RT
Dia " Sch

I want to copy data from Drawing no, spool no, joint no, size dai, size sch, welder id

IF Welder ID is Greater than ZERO .... AND ........ RT is Less than ZERO, to Sheet2.

Data entry is done on Sheet1. I want to Sheet2 to be updated AUTOMATICALLY, based on given range of data

Can anyone help me work out this

Regards,
Prashant