Hi,

i am trying to work around codes where i copy values from one range of cells and paste it in other column on the same sheet

Example
I have Column D with values like 25,35,14,62,25,100,105 in rows D2,D3,D4,D5,D6,D7,D8 Now i will select D2,D3,D4,D5,D6,

and when i click the macro it should copy the above selected values in Column C in rows C2,C3,C4,C5,C6

so as u can see jus the column changes but the rows remain the same.

Also everytime Column D will be the place from where i copy the values and column C will be the place where the values will be pasted

Any help would be a life savr