Macro Transpose Data [Kaper's Code]

[Jhon Mustofa]

hi expert...

i want to add data in a new column (e.g. sequence number), i have trying to modify Kaper's code but not success, here this Kaper's code..

Please Login or Register  to view this content.

previous post in http://www.excelforum.com/excel-prog...-criteria.html

please, check attachment

could you help me out? much appreciated....

john m

[xladept]

Hi Jhon,

Try this:

Please Login or Register  to view this content.

[xladept]

Hi Jhon,

Thanks for the rep!