PDA

View Full Version : Please help in auto data classification based on mapping



khaledocom
04-16-2012, 12:08 AM
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
05-07-2012, 08:55 AM
Hi all,

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

Tinbendr
05-08-2012, 09:17 AM
See if this attachment is what you need.

khaledocom
05-08-2012, 12:37 PM
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
05-08-2012, 12:47 PM
I understand now, I think.

Back to the drawing board.