Copy specific row cell and insert into Next line

[yan nian]

Dear all,

I have a raw data and i need to sort it in a proper manner by using VBA macros( create a function and embed into a button only one click). I've attached the illustration in an excel file. I need advice and guides on how to do this or is there any sample reference, thank you.

 

[Marc L]

Hi !

The advice is simple : SourceRange.Copy DestinationFirstCell
as you can read in VBA inner help …

Clearly explain in a new post your need with some clean workbooks
(a before and an after), as clean just means
respecting the real data structure without any comment …
​

 

[yan nian]

Thank you Marc L, i will do some research on this, and noted for the attachment part.