Update from one sheet the other

katietempletoe - Jan 10, 2018 at 04:49 AM

I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving systems and I am storing and updating all employee info in Excel - if there anyway I can get excel to automatically update if I have a key bit of information linking the update and the current info?

i.e. if there employee code matches on sheet 1 & sheet two any differing info on sheet 2 will be overwritten on sheet one?

The goal is to fill out of the changing info on sheet to and for it to feed into sheet 1