One more question one of the problems that I have come across the most is that I get e-mailed tons of DATA sent by my higher ups. The problem is that instead of using several workbooks for the data they use 1 (All the Time)!! In the workbook they have all of the schools in the district on seperate worksheets. My job is to change the data on the worksheets and then send the file back EXCEPT they don't want the individual school that I send the file to see the whole file. They just want them to see the individual worksheet for their school!!! A couple of methods that I use is to hide all of the other worksheets in the workbook or I cut and paste!! Does any one have any VBA Method that would take care of this problem!!!!!!