Results 1 to 3 of 3

Thread: Any excel gurus on here?

  1. #1
    Join Date
    Jan 2012
    Posts
    117
    Mentioned
    0 Post(s)
    Quoted
    12 Post(s)

    Default Any excel gurus on here?

    So I have a pretty in depth task to do with excel (at least to me it is). This is for a company that reviews the shipping information for other companies. I was given 2 separate lists of companies that hold a shipping contracts with the company that checks the shipments. (confusing already I know) Anyways, one list is about 13000 lines and the other is about 11000 lines...every name on the list of 11000 is on the list of 13000 but if the name is not on the 11,000 it is irrelevant to this task. Basically each name will be given a status based on whether or not the information matches up.

    as follows:

    1. Addresses much match on both lists
    2. Status must be know on the 13000 entry list (master list)

    if both conditions are met then a TSA number in the same row must be added and highlighted in green to the 11,000 list after the name that it belongs with. If the status is know and the addresses are different then it must be added to the 11,000 list after the name it belongs with, but instead in green, and if the status is not known the same must be done but only it needs to be highlighted in red.

    This already seems difficult to me, however to take it one step further, the addresses were hand typed over the years and the addresses that belong to a Name on list one may be the same as on list 2 but only slightly different

    example: 123 N Miller Road --> 123 North Miller Rd. (these are the same but obviously typed differently)

  2. #2
    Join Date
    Jun 2007
    Location
    The land of the long white cloud.
    Posts
    3,702
    Mentioned
    261 Post(s)
    Quoted
    2006 Post(s)

    Default

    Is this correct:

    So on the 13000 list you have [Names, addresses, status] i.e. in colums A, B, C
    and on the 11000 list you have [Name, address, status, TSA number]

    If the name, address and status matches, then the TSA number (on 11000 list) is highlighted green.
    If the name, address but NOT status match, then the TSA number is highlighted red.

    It is possible to do this without a macro, but the addresses would have to be an exact match.

  3. #3
    Join Date
    Jan 2012
    Posts
    117
    Mentioned
    0 Post(s)
    Quoted
    12 Post(s)

    Default

    Quote Originally Posted by The Mayor View Post
    Is this correct:

    So on the 13000 list you have [Names, addresses, status] i.e. in colums A, B, C
    and on the 11000 list you have [Name, address, status, TSA number]

    If the name, address and status matches, then the TSA number (on 11000 list) is highlighted green.
    If the name, address but NOT status match, then the TSA number is highlighted red.

    It is possible to do this without a macro, but the addresses would have to be an exact match.
    This is about right, but there are multiple columns , just the only columns that matter are what you listed as A, B, and C. The problem is that both list were hand typed by 2 different people and contain errors....like I've seen the same company name on the master list 5 times spelled slightly different each time. And since these list are 2 different spreadsheets how would I go about making the macro? (I have very limited excel knowledge unfortunately :/)

Thread Information

Users Browsing this Thread

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

Posting Permissions

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