Creating a Simple macro

[Raaz74]

I am new to this site and very new to Macro or programming..

Very simple quesetion !! I need to create a macro to copy data from any column and paste it to different column

Data could be in Column A B or any column and paste it to any other column, please assist.

Another question...lets say if column "B" has different data, do i need to highlight this data when i run the macro or just run the macro.

Any help would be apperciated.

Thanks
-Raaz