hello!!!
i have 3 work sheet on a book and all are identical with 10 columns and 30 rows. first column is formated as date,2nd is currency,3rd is text,4ht is number.

here i smy question:

if i enter the text "xxxxxx"in 3rd column of sheet 1(other columns are entered with date,currency,and number etc..) it has to fill all the corrosponding columns of sheet 2, just what i entered in sheet3.

if i enter the text"yyyyyy"in 3rd column of sheet 1(other columns are entered with date,currency,and numberetc..)
it has to fill all the corrosponding columns of sheet3,just what i entered in sheet3now.

i do not know how to solve this problem if any one knows solution for this please reply.

thanks in advance