+ Reply to Thread
Results 1 to 2 of 2

vba for comparing columns

  1. #1
    Forum Contributor
    Join Date
    02-11-2008
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    242

    vba for comparing columns

    Hi,
    In the attached sheet,I am going to compare desc of column "S" and write the details in column "T" . For example
    Accronym Desc
    BT BTS
    MW Minilink / Access Link
    BS BSC
    MS MSC
    IN IN
    TE Transmission
    TS Transmission
    NM OSS
    SE Services
    AN GSM antenna
    NL NLD-OFC
    MP MPBN
    VA VAS
    TW Civil & Infra
    ST Civil & Infra
    for this I have written the below code,but the problem I am facing is if I run the macro I am getting one desc,pl advice in solving the problem
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by arnab0711; 01-22-2011 at 06:57 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: vba for comparing columns

    Given your use of >= etc I'm not entirely sure I follow the requirements but perhaps:

    Please Login or Register  to view this content.
    of course if you stored the acronym table in your file you could just use a VLOOKUP.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1