I need to update "salesdb" sheet from "sales" sheet. If any change in Sheet "Sales" it should automatically update "Salesdb" Columns from "Sales" A to sheet salesdb D , B to Sheet Salesdb A, C to B and F to F. And also when its copy on c to b of salesdb it should check userid from "Custid" sheet and do no copy duplicate rows.. you can check my code . http://sdrv.ms/LUfsea . I tried one code which is on module6 with FillSalesD. Pleses help me