Hello all,

I thank you for giving me your attention in this matter. I am not an Excel power user at all, I use it for basic tasks and have not done a lot to explore the massive functions available to it yet. But I just came back from a vacation and discovered that some people in our office had taken an Excel file and copied it to their desktop instead of creating a shortcut to the original file and now we have a few weeks of data (entered every day) that is now split between 2 copies of the same file and I need to know if there is a way to combine these separate files back into one file without losing the changes made to each? So pull all the data that was entered into the one into the other without re-entering the data manually.

I appreciate any help that you can give me and hope to hear from you very soon.

Thank you,
Martin