PDA

View Full Version : [SOLVED] Code to match to cells using a mapping



Kartyk
12-29-2016, 12:47 AM
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

Kartyk
12-29-2016, 11:12 PM
Any luck with this one ?

Aussiebear
12-30-2016, 12:29 AM
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.

Kartyk
12-30-2016, 12:44 AM
Sorry, if that offended you. Not my intention. Will be careful the next time.