Please help in auto data classification based on mapping

[khaledocom]

Hi all,

I need your Urgent help with regarding the attached XL file.
it contains two sheets, on is the called date, the other which I want to classify data in. I need a macro to do that shown in the attached file.

Thankful for you help.

[khaledocom]

Hi all,

I've changed the layout it may make it simple, please find the attached file:

[Tinbendr]

See if this attachment is what you need.

[khaledocom]

Thanks David,

I need a macro to build data in "Raw" database in a new sheet as shown in "Required".

The data in "Raw" sheet is being changed weekly and every time I have to structure or map it as shown in "Required"

I can get values by using VLOOKUP as you mentioned.

Thanks again.

[Tinbendr]

I understand now, I think.

Back to the drawing board.