Need help.......about Excel and Macro

[Irmann]

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

1st excel name is Operation file and the other name is NPI file. Bot
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 at Xfer
at Operation file. I want make it automatically copy and paste that ne
data(any changes) in Operation file to NPI file by click 1 button(follo
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 mak
sense.

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

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

plz someone help me......