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 at 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.
The problem is 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.
Can that system been done by using macro? and how ? Im not the IT student... huhu
plz someone help me.......