I can do whatever i want with it, i have also found a problem where when i send the seperate worksheet off it becomes corrupt and i don't know if that is the macros or data validation