I got two excel file in difference location. Both save in sharing folder at company server.

1st excel name is Operation file and the other name is NPI file. Both have Product name, Package, Actual Ytd at Xfer and Actual PML at Xfer. Engineer will key-in the data(Actual Ytd Xfer and Actual PML Xfer) at Operation file. I want make it automatically copy and paste that new data(any changes) in Operation file to NPI file by click 1 button(follow the same product name and package). I know i can use formula( using ' = ') for every box, but my company got so many product and that not make sense right.

Every week or every month got new product with the difference package coming in. For example row 15 have product name Kirin2U, package 64LGFP next week or month got new product coming in, product name Kirin2U, package 123HJGH same product name but difference package. The new product automatically will put in at row 16 under same product name. The table will push down to 1 because give ways to the new product.

How can i pull out the changes data(Actual Ytd Xfer and Actual PML Xfer in Operation file) to the right place(cell) at NPI file.....


The problem can be translate as:-

[
IF
'product and package at operation file same with product and package at NPI file = true'

Than
'can copy and paste the value of Actual Ytd Xfer and Actual PML Xfer from operation file to NPI file'
]


Can that system be done by using macro? and how ? Im not the IT student... huhu

I do have some programming skill.....

plz someone help me.......