2G macro to creat NBRs needed?

[echomoon]

Dear all can somehelp in creating NBRs of a 2G/3G Network using simple macro?
i need to creat NBRs from OSS dump file(.xlsx),two column had this info :SourceSeg,TargetSegment
example:




SourceSeg
TargetSegment


cell A
cell B


cell B
cell A


cell B
cell C


cell B
cell D


cell B
cell E


cell C
cell F


cell C
cell x




into:

CELL NBR1 NBR2 NBR3... ....NBRn
cell A cell B
cell B cell A cell C cell D......


thanks in advance

[zaebolll]

You can use attached macro for that work

[mhut]

Dear all can somehelp in creating NBRs of a 2G/3G Network using simple macro?
i need to creat NBRs from OSS dump file(.xlsx),two column had this info :SourceSeg,TargetSegment
example:




SourceSeg
TargetSegment


cell A
cell B


cell B
cell A


cell B
cell C


cell B
cell D


cell B
cell E


cell C
cell F


cell C
cell x






into:

CELL NBR1 NBR2 NBR3... ....NBRn
cell A cell B
cell B cell A cell C cell D......


thanks in advance
You can use this tool
http://www.finetopix.com/showthread.php?30288-Tool-convert-relation-cell-cell-to-cell-list_celll&p=183673#post183673

[khatib86]

You can use attached macro for that work

How to use this tool??

[zaebolll]

How to use this tool??

after filling your data press alt+f8, then run that macro

[scape]

very easy.!@@@@@@@@@@@@@@