I have a master employee worksheet with about 20 columns (name, position salary, seniority, etc.) and over 1000 rows (all the employees). From this I created a second worksheet to calculate year-end bonuses. Now, I need to check my bonus worksheet against any changes which have been inputed into the master worksheet such as changes to an employee's salary, position, etc. How do I do this? Do I need to create a third worksheet or use Vlookup in the bonus worksheet? Clearly I've been given a task I'm not quite qualified for. Please help.

That's a tough question to answer without more detail. Some "updates" could be done automatically by using formulae, such as =Sheet1!A1 Any changes to that cell in one sheet would be reflected in the other sheet automatically. Existing formulae working on that cell would still work. VLOOKUP might be required - as well as other functions - but you haven't given us enough detail to give you any specific answers.

Hi DerbyDad, A little more information: the two work sheets are actually two separate files. I don't have access to the real master, but only a modified version with the information I need. Because I am looking across rows for any changes, should it be an Hlookup? Is there any other specific information I can give that would help? Because I'm not 100% sure what I'm doing I'm not sure what's needed to solve this. Thanks for your help DD. Mulli

Is there a way to post a version of the worksheets using dummy data? This might help present visually what I'm trying to explain.

First, if they're different workbooks (files) call them workbooks; if they're different sheets in the same workbook, call them sheets or worksheets. Things will just get confusing otherwise and the wrong suggestions may be given, such as when I suggested =Sheet1!A1. Once again, I can't tell you if you want to use VLOOKUP, HLOOKUP or any other function without knowing what you want to do. Comparing data across worksheets/workbooks is very different than actually pulling data from one worksheet/workbook to another. You can't post Excel files in this forum. I'll send you an email address via private message. Send the file(s) in an email, with an explanation of what you are trying to do and I'll see if I can help.