Raj,

Welcome to the forum.
At what time do you want the data to be copied to sheet2?
You have several drop downs and from the info you provided I would assume you want to copy the row of the selected Item to sheet2. if this is correct and the selection will be the last entry to select from then you can use a "Worksheet_Change" event to copy the data to sheet2.