I won't go into the details of why I need this, but it is very important because all of the users at work are screwing the spreadsheet up no matter how much i try to protect it.
There is only one sheet that data is entered. They need to be allowed to move data from cell to cell, without changing formats and formulas.
Basically. I want them to be able to "copy and paste" and "drag and fill" ONLY. When they do, I want them to move "values" ONLY.
I have tried to teach them how to paste special, but they keep screwing up the sheets, and I want to make it mistake proof.
I am very well versed in excel, but I just have a little bit of surface knowledge in VBA. Is there some code that can do this for me?
Thank you. This is my first post.
Bookmarks