Hi TMShucks,

I have done this already and I'm not concerned about them changing data etc I just don't want them to have to open both workbooks manually in order to get them to work. I want the end user just to have to open the working doc and the info from the master data doc to be automatically available.