How to generate + populate new worksheets according to cell value

Good Morning All,

Doign some late night company work and wish i would have listened to my colleague more and backed up all the needed files to my USB stick to take home to work on.

To cut a long story short - :

Just compiled an excel sheet with 3 years of data spread across 1200 lines.
Basically the data consists of 5 values for about 120 different companies. Some have more than one transaction hence the 1200 lines In essence i need a makro that takes all the UNIQUE NAMES (example 3i Group Plc or Aquarius Platinum or Ashmore Group plc - etc etc etc... ) from column C and pastes them into a new sheet for each company.

Would appreciate any help as i left the file containign a pre written makro in the office and am in a deadlock here at the moment.

Thanks