VBA copy and paste value

I wish to copy the value from column A to column B with the condition only value from column A is copy to column B, value of column A is removed without removed or changing in any formula in column A. Currently i only achieved to copy from column A to column B but value at column A still remain. how do i should coding in VBA

How to coding the undo at user form??

anybody can help me..


i uploaded a file for ur concern