copy paste delete cell contents
 

I need a macro that copies data from one location in a workbook, pastes the
values only into a location in another workbook and then deletes the original
data. Every time I run the macro it has to pick up the data always from the
same range of cells, but paste them into a new range of cells every time (new
cell range is always one column to the right of the previous). Anybody help?