Dear Excel experts, I want to design a mechanism for my postal addresses management
I have sheet in which I have write address like this
[TABLE="width: 1154"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][TABLE="width: 1156"]
<tbody>[TR]
[TD]Sr. #[/TD]
[TD]Consignee Name[/TD]
[TD]Consignee Address[/TD]
[TD]Consingee Contact Number[/TD]
[TD]Sender[/TD]
[TD]Sender Name[/TD]
[TD]Sender number[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mr. Muzzafar Iqbal[/TD]
[TD]Sun Crop Pesticides Factory, 8-D Industrial Estate , Multan[/TD]
[TD]0300-5703705[/TD]
[TD]Saver Enterprises[/TD]
[TD]Anas raza[/TD]
[TD]992653954[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Saver Enterprises[/TD]
[TD]Anas raza[/TD]
[TD="align: right"]992653954[/TD]
[/TR]
</tbody>[/TABLE]
HOW I CAN achieve postal address like this. (Pivot table, .VB)
Mr .Muzaffar Iqbal
0300-5703705
Sun Crop Pesticides Factory ,8-D Industrial Estate , Multan
____________________________________
From:
Saver Enterprises
0340-7862111
041-8810034
I have sheet in which I have write address like this
[TABLE="width: 1154"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][TABLE="width: 1156"]
<tbody>[TR]
[TD]Sr. #[/TD]
[TD]Consignee Name[/TD]
[TD]Consignee Address[/TD]
[TD]Consingee Contact Number[/TD]
[TD]Sender[/TD]
[TD]Sender Name[/TD]
[TD]Sender number[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mr. Muzzafar Iqbal[/TD]
[TD]Sun Crop Pesticides Factory, 8-D Industrial Estate , Multan[/TD]
[TD]0300-5703705[/TD]
[TD]Saver Enterprises[/TD]
[TD]Anas raza[/TD]
[TD]992653954[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Saver Enterprises[/TD]
[TD]Anas raza[/TD]
[TD="align: right"]992653954[/TD]
[/TR]
</tbody>[/TABLE]
HOW I CAN achieve postal address like this. (Pivot table, .VB)
Mr .Muzaffar Iqbal
0300-5703705
Sun Crop Pesticides Factory ,8-D Industrial Estate , Multan
____________________________________
From:
Saver Enterprises
0340-7862111
041-8810034