Macro to copy selected cells and paste them in the same row but in a different column

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

Hi you could use the following code to achieve what you are trying to do.

Please Login or Register  to view this content.

Hi Excel Guru, but every time my selection will be different in column D, can we have the code such that it work for any cellls in column D

Hi Nirmall what criteria defines what you select in column D?

Hi Excel Guru, i Jus select the data to copy in column C, now since there will be a lot of entries i need to have a macro

Hi Nirmall, if you do not have a predefined criteria to select first then you cannot create a macro to do this otherwise how would the macro know what to select and what to copy and paste?

I will select the cell, then run the macro to paste the cells i have selected

Maybe:

Please Login or Register  to view this content.

Let me try that

its working great, one last thing, is there are way to paste values with format and not formulas

Try:

Please Login or Register  to view this content.

Works like a breeze

Glad to hear that. If that solves the issue please mark this thread as SOLVED.