Thanks Thanks:  5
Showing results 1 to 6 of 6

Thread: 2G macro to creat NBRs needed?

  1. #1
    VIP Member Reputation: 1478
    Join Date
    2011-01-01
    Location
    Earth
    Posts
    652


    Default 2G macro to creat NBRs needed?

    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

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. #2
    Member Reputation: 271
    Join Date
    2008-12-16
    Posts
    213


    1 out of 1 members found this post helpful.

    Default Re: 2G macro to creat NBRs needed?

    You can use attached macro for that work
    Attached Files Attached Files

  4. #3
    Member Reputation: 42
    Join Date
    2012-06-14
    Posts
    22


    1 out of 1 members found this post helpful.

    Default Re: 2G macro to creat NBRs needed?

    Quote Originally Posted by echomoon View Post
    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....673#post183673

  5. #4
    Member Reputation: 494
    Join Date
    2011-03-01
    Location
    Mars
    Posts
    296


    Default Re: 2G macro to creat NBRs needed?

    Quote Originally Posted by zaebolll View Post
    You can use attached macro for that work
    How to use this tool??

  6. #5
    Member Reputation: 271
    Join Date
    2008-12-16
    Posts
    213


    Default Re: 2G macro to creat NBRs needed?

    Quote Originally Posted by khatib86 View Post
    How to use this tool??
    after filling your data press alt+f8, then run that macro

  7. #6
    BannedUser-MultiAccounts Reputation: 49
    Join Date
    2007-04-29
    Posts
    225


    Default Re: 2G macro to creat NBRs needed?

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

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •