I just thought of something with regards to the code. This code sits on the spreadsheet and I was trying to put the code on Excel so that the user could run it after opening up the new spreadsheet that will get sent on a regular basis with new data. Does Excel have a global location where the data can be put and then the user can run it on the new spreadsheet. Sort of like the Normal.dot in Word.