Excel Formatting Report Using Macros

Question

I am looking at formatting a report which has been automatically generated by a 3rd party system. As we have no access to the Database directly i would like to build a Macro which would format the report into a more readable format.

I had initially thought about ingesting this raw data into a database as i am pretty competent a writing the SQL queries, however i think it would be easier if someone could run this through a macro.

The initial report shows which users have attempted which training modules and their completion status.

N.b. A user may have completed a module several times, therefore will appear multiple times.

The link below is the spreadsheet with two sheets, sheet 1 is the raw data and sheet 2 is how i would like things to appear.

https://www.dropbox.com/s/p1hipx17q3mf3dm/Learning-Report.xlsx

Any help / ideas would be much appreciated as i am pretty new to the whole macro's in excel thing.

Many thanks

Ian

Answer 1

I am answering in the same manner the question is phrased so please bear with me...

1. Identify all unique employees (for rows)
2. Identify all unique courses (for columns)
3. Find all the attempts and compute a. Highest Score b. Status
4. Put the data in the second sheet.

See if the question has been precise... the answer would also be to the point.