|re: "When i am find a code in sheet 1..."|
What do you mean by "code"?
How would you be searching for whatever it is that you are searching for?
Will Sheet2 always be empty before each search or are you adding (appending) rows to the bottom of the existing data each time?
We need a lot more information before we could suggest any VBA code.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.