I have a user who needs to combine or merge two worksheets. He received one worksheet from human resources and the other from the state - the one from HR is more current and he needs to take that worksheet and add it to the state worksheet. The problem is that the state lists certain employees, say 1-1000 and they are sorted by SS#s. The HR lists new employees also in order by SS#s. How can you insert the new employees - into the state worksheet and keep the order the same. The state worksheets have blank columns that I want to populate with the HR info. I know this is hard to understand or maybe I just cannot explain it correctly. I looked at sharing documents and accepting and rejecting revisions, but the documents are NOT two versions of the same file. They are two separate workbooks.