PDA

View Full Version : [SOLVED:] VBA to create a mapping



Kartyk
01-01-2017, 11:11 PM
Hi,

I am looking to merge for a code ( to merge with a bigger code, that I have in place) to create a mapping. Pls find the description below and also a sample attachment.

* 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