I am new with macros and i am not able to solve this problem. If
someone could help me , I would really appreciate that .

1- I have 3 tabs in this worksheet with the data
- Tabs A , Master Data and refernce Table
2- Suppose column K in the tab " Master Data " has a record or number,
they can be repeated as the new data us added every month.

3- Reference table has the list of the same data record ( numbers ) .

Now the situation is if there is a new record in the column K of the
master data sheet the Macro should do the following.

a- Check for the record in the refeence table , if doent exist
then add the recor in the reference
table

b- create another sheet same as the sheet " A" (duplicate of
A)
b- Plug the new record number in the cell B2 of the new sheet

c - Copy the row 8 from ( D8 to O8 ) in the new sheet from (D8 to
O8)from sheet A
Thanks