Need help writing a macro to simplify my work for my business. My excel sheets are part numbers in a column with descriptions, reference numbers and pricing info in its corresponding line.

I need to be able to check column A in worksheet vendor part number against column A worksheet My part number and if vendor part number is not found in worksheet my part number then have it copy the new part number that wasnt found in worksheet my part number and all information in that line to worksheet new parts.

I have been just simply copying the two columns and comparing and manually copying the information and then using find to find the part number in the vendors and manually copying each over. I deal with over 10,000 parts. Very time consuming. I have worked with formulas but have not as of yet written a macro. Need help with this please.

Naunid