http://www.neilcarden.co.uk/example.xls

Please see above file... I have a sheet (import) which is tha raw report from an application, I want to sort it in a similar way to LOOKUPs where it looks for the agents name, and returns the data as in sheet 2 (Formatted).

How easy is this to do? as some days not all the codes will be used so the raw data will not always be in the same format regarding number of rows before going onto next person etc...

Thanks in advance
Neil.