Does anyone know if it is possible for a user to copy a cell or range of
cells from column and then paste in the same column? I want to prevent the
users from copying a cell then pasting into another column that is formatted
differently.

Any advise would be greatly appreciated!