Excel macro to create new workbook and copy data [Closed]

Report
Posts
2
Registration date
Friday August 25, 2017
Status
Member
Last seen
August 25, 2017
-
In the example below, I want to create five new excel files with the same heading and the data should be copied based on the unique Line numbers (Column C). Please help me if this could be possible in any way. It is much appreciated.

Original Spreadsheet

http://static.ccm2.net/ccm.net/pictures/7RtGNvNU1Sadh87AiGv6jesQPqHq7DvxNG0ldWP6PxGRZIddGzDOeY82huQEW6GH-excel-macro-1.png

New File 1

http://static.ccm2.net/ccm.net/pictures/rarNLEZ7iE7dkdBikiRip3LVfd1k7e8BC8kMt7qzrIJ5Ij5esHyZhDBhNjWSk3MK-excel-macro-2.png

New File 2

http://static.ccm2.net/ccm.net/pictures/ivzXkbwNm47bcr8mJOuNyVkf1DQQjjLB6nrFmxgHftK4adm3rRI1RqSgEIxHog30-excel-macro-3.png