+ Reply to Thread
Results 1 to 5 of 5

two tab post codes match

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    two tab post codes match

    Hello Experts,

    I have 2 tabs firs one is data and second is post codes, post code are two type 1st one is available on data file but 2nd is not available, I want to match data tab post code with post code tab and I need there specific 2nd post codes, please check the examples in screenshots and also you can check excel file.

    Thanks in advance

    farhan
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: two tab post codes match

    Create a sheet named "result" where the result will be placed.

    Use this macro-

    Please Login or Register  to view this content.
    Check attached
    Excel Forum - 1266.xlsm
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: two tab post codes match

    Hi Sourabh,

    Thanks for my help, Result only show 11 rows, I have bulk of post codes data, can you please increase rows to last cell of column?

  4. #4
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: two tab post codes match

    It should work till the last cell of Column A of Data sheet.

  5. #5
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: two tab post codes match

    Thanks Sourabh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help needed to amend the format of certain Post Codes
    By sx200n in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-23-2014, 08:35 AM
  2. [SOLVED] Post Codes with Different numbers with Different Postage Costs
    By steve_bee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2013, 11:28 AM
  3. Filter post codes
    By davidx in forum Excel General
    Replies: 9
    Last Post: 06-28-2013, 05:45 AM
  4. Matching post codes to areas
    By radmar1985 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-08-2013, 09:38 AM
  5. help with post codes
    By RajD69 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2013, 11:24 AM
  6. Combined Post codes
    By mikeconomy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2011, 11:39 PM
  7. Post Codes
    By excel_lover in forum Excel General
    Replies: 5
    Last Post: 09-11-2008, 08:09 PM

Tags for this Thread

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