Creating a Simple macro

[Raaz74]

Thank you for your prompt rersponse. Okay this is what i need

Lets say column E has some values and it does not matter if column B has values or not, what i need to do is move values from column E to column B, again once i hvae this macro for E and B in future if i need to move data from any column to any column i can change column name right?

B E
----------- --------------------------------
2 3
3 43
33 332
334 343

Please assist. Also, please advise if i need to highlight values in column E when i run the macro?

Thank you,
--Raaz