Macro copying rows to coulm based on specific criteria

[srinivasan1965]

Hi all
I sincerely thank all the members of forum.
I am really in a need of a help for copying row to colum based on Acoulm I have done example for the first few
This arrangement is required for writing letters through mail merge.
Your immediate help is sincerely solicited
Illustration is attached

Thanks & Regards
N.Srinivasan

[nilem]

Hi N.Srinivasan,
try it

Please Login or Register  to view this content.

[srinivasan1965]

Thanks a lot
It works great
many thanks for reliving from me doing from monotonour work

[srinivasan1965]

Hi
Can you Please help
I need to copy row to coulm Exaample file is attached.
Previoous verison had 3 colums to be distributed now One more colum is added pls help

[nilem]

try this

Please Login or Register  to view this content.

[srinivasan1965]

Hi
Hi
I need one more help.
Row colum is to be arranged based on the colum A and B to gether
Presently it is following colum a
If there are more than on flat in tower 4 it combines in the same row.
can you please extend this coding.
thanks

[srinivasan1965]

Hi Nilem,
I have missed to thank you very much your coding on 25/04/2016. It works fine and superb.

Now can you please help me to give coding for the above post.
Presently it looks colum A for every change in colum A it arranges row to colum wise
We have above 10 towers and each tower shall have same flat no.101 102 etc.
Coding shall look for change in colum A and Colum ie tower no flat no and then arranges to row colum
can you pls help.
Thanks