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