VBA copy data to another worksheet based on criteria

Hi all
I'm pretty new to the VBA world and looking for a little help. What I like to accomplish is the following:

I have a master workbook on sheet 1 with two macros attached to buttons and sheet 2 (Category Table) with two columns: "Codes" & "Department" (20 records).

I'm trying to create a new macro which should open an excel file (Category.xls) with around 30,000 records and copy/paste the codes from the category table into column A in Category.xls. Column A is for Codes and Column B is description. Many of the description names match with the department names in the category table, but the codes show "0" and I want to copy the real code. For the items that do not match with the category table and has a "0" in the "Codes" column, I want to delete the entire row. Attachment 197111Attachment 197112

Hope I'm not making it too confusing.

Thanks for reading and I appreciate any help.

Your attached pictures are unreadable. Please attach sample workbooks. In the samples, perhaps show BEFORE/AFTER sheets so we can see how it starts and how it should end, on a dataset of 10-20 rows.