Copy row values in a single column

[ashish mehra]

Hi,

I need help in completing this project copying values from rows to a single column till the last row of data.

I have done through recording but since there are many rows in which I find it difficult to streamline my code to work properly.

Many thanks in advance.

Regards,
AM

 

[Somendra Misra]

@ashish mehra

See the file, the output will come in column C from the macro.

Note, it will take some time to loop through large number of rows.

Regards,

 

[ashish mehra]

Thanks SM,

You have saved me otherwise I have to work in night to finish this work.

You are truly a magician.

Regards,
AM

 

[Somendra Misra]

@ashish mehra

Thanks for the feedback and you are welcome.

Regards,