I'm not going to give you any code but a hint. From there you can start coding.
I'm assuming you know how to add reference on Microsoft Excel and Import Microsoft.Office.Excel.
-> Declare a variable as and Excel.Application
-> Declare workbookA and workbookB as Excel.Workbooks (data will be copied from workbookA to workbookB, workbook1 will have the original data and workbook2 is a blank workbook)
-> create new workbook for workbookB and Open workbookA
-> copy data from columnA to column C of workbookA, activate workbookB and paste data. Do until row of workbookA is empty.
Please google for more information. Hope this helps!
Glad to see you already solved your problem.
Here I'd provide code snippet in VB.NET for copying worksheet in Excel, hope it can be helpful.(P.S. You have to add .NET Excel.dll as a reference in your project before using the below code)
Private Shared Sub Main(ByVal args() As String)
Dim workbook As Workbook = New Workbook
Dim worksheet As Worksheet = workbook.Worksheets(0)
'add worksheets and name them
'copy worksheet to the new added worksheets