I was wondering if anyone could help , 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
Thank you very much if you can offer any advice, I appreciate any time\effort given.