Macro to analyze the Raw Data

**dobracik** · 11-09-2012, 11:14 AM

Hi all

I'm quite new in VBA coding, therefore I would like to ask if somebody is able to help me

I have a complex Raw Data with the evaluations in one sheet. I want to have some marco to create new sheet with Agents name in first column and caledar dates in a row.

Macro should create new tab, table and if code find the agent name in raw data, should copy the evaluation's results from raw data acoording to the date ( Pass / Fail) to the created table.

I was trying to use the lookup function, but not working.

Thank you so much for your help,
Andy

**Norie** · 11-09-2012, 11:19 AM

Andy

Can you attach a sample workbook?

**mike7952** · 11-09-2012, 11:19 AM

Andy,

Would a copy or a mock up of your workbook with expected results to be able to assist with your problem. Please upload a wb.

**dobracik** · 11-09-2012, 11:32 AM

Hi

See attached the sample - In Raw data, I've marked those columns, which I should take in consideration.

Macro, should create Summary tab.

Forgot to mention, that dates are changing depending on fiscal period.

Thanks a lot lot

**Naveed Raza** · 11-11-2012, 09:36 AM

Hi,

i updated the formuales and plz have review to attached file and let me know if u hv any queries.

anything else u want to know feel free to discuss

Thanks - Naveed

**Naveed Raza** · 11-11-2012, 10:42 AM

Hi,

If ur query got resolved and u satisfied with this solution then Dont forget to Mark SOLVED.

Goto ur 1st post - Goto Thread Tool - Select Mark this thread as solved.

**dobracik** · 11-11-2012, 12:29 PM

Hi Naveed :-)

Many thanks for this, Is working. I'm just worried, if I have a lot of rows ( 15000) file will be too slow.

Thanks ,
Andy

**Naveed Raza** · 11-12-2012, 02:52 PM

Hi Andy,

don't worry its not a Array Formula its general normal vlookup if u have data till Lakhs then also it will work perfectly with accurate speed and data.

Don't worry and If ur query got resolved and u satisfied with the Solution then please don't forget to Mark this thread as Solved.

Goto 1st Post - Goto Thread Tool - then Select mark this thread as Solved.

Thanks - Naveed.