Need to copy from sourcesheet to destination sheet only the new data entered based on seri

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found then just copy the data's from the rows of the other 4 columns also and then paste in to the destination rows of the specified column there in Sheet2. Till this step I have done it successfully. Now the users are entering new data to the source sheet the next day and I only need to update those data to the destination sheet. The new data can be selected based on new Serial no on the sheet1 which is available in coloum "A". For every new entry they enter a increased serial number (Which is unique). so If I can check the "Ferro Manganese" condition from the newly entered serial number (from the point Serial no increased) then I can only copy those new data to the destination sheet using the successful code i am attaching it here. I need to learn how to write that extra if condition for increased serial no condition depending on which the paste function will work for only the new data. Due to office data populated in the sheet I could not upload it. But from the code the description I think you masters will understand it easily.
Please help me.

Please Login or Register  to view this content.

2 things.
1: Read the forum rules (#2) about code tags and #3 about cross posting.
2: Read about cross posting here.
http://www.excelforum.com/forum-rule...rum-rules.html
or here
http://www.excelguru.ca/content.php?184

Put code tags around your code in Post #1 first.
There are no hyperlinks to the other posts, where ever they might be, either. That goes for all sites where you posted.
Add an attachment with before and after and an explanation of how you arrived at the result.