Consulting

Results 1 to 4 of 4

Thread: Code to match to cells using a mapping

  1. #1
    VBAX Regular
    Joined
    Apr 2016
    Posts
    67
    Location

    Code to match to cells using a mapping

    Hi All,

    * Match column "Bank" between two lines
    * RBS is short for Royal Bank of scotland
    * Mapping sheet provides this abbreviation
    * Code to look up mapping sheet and then pass this as they are the same
    * Code can match only the first 4 letters after mapping the abbreviation.

    Inshort, RBS = Royal bank of sctoland

    Matching Roya = Roya between two rows.

    Cheers
    Attached Files Attached Files

  2. #2
    VBAX Regular
    Joined
    Apr 2016
    Posts
    67
    Location
    Any luck with this one ?

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,060
    Location
    Oh come on Kartyk. You simply define a set of demands without any preamble and then expect others to comply, surely you have better manners than that.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Regular
    Joined
    Apr 2016
    Posts
    67
    Location
    Sorry, if that offended you. Not my intention. Will be careful the next time.

Posting Permissions

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