Automatically Paste Special Values and Proper Case

[coreyjames]

I am working on a template for all of my co-workers to use. I want to make this as simple and efficient as possible for them. We will be cutting and pasting clinical data from various worksheets into our template. I want the template to automatically paste special values anytime anything is pasted. For example when I copy something from another open worksheet and go to the template and press ctrl+v I want it to automatically paste special values. I also want the template to automatically "Proppercase" the entire worksheet anytime anything is changed, pasted, or added manually. I would like all of this to work without needing to physically run a macro. Is there a way for this to all be done in real time on the fly? Thanks!