Case options, finding a value, copying the value to the left and pasting on new sheet.

[emilyloz]

Attached is my workbook. we will be looking at sheets, "Reason Codes" and "Modify Data"

In the sheet Reason Codes there is a list of codes:

RSNCDE
BB
BDS
C
CHT
CRG
D
DEL
....

and to the left of these codes are numbers that correspond to that specific code.

On the modify data sheet, there are a bunch of entries and column E contains a specific Code.

I need a way to run through these codes from the "Reason Codes" sheet, match it with the E column in "Modify Data" and paste the corresponding number in the F column on "Modify Data"

I've never worked with cases before.
Ive thought about If statements, but that would be way too many statements,
and i'm hoping theres a way to use autofilter of some sort.


Thanks!

[AB33]

Emil,
Formula
In F3 and drag it down

Please Login or Register  to view this content.

[emilyloz]

AB33,
Is it possible to do that through macro?

Just because when I run the macro to transfer the data from claimskl to modify data, it clears the contents on the sheet.

[AB33]

The code works on exact match only. I have created a new module-3

[emilyloz]

Thanks! works perfectly.