New to VB and macro

[Blastphemist]

I'm trying to take a csv file and dump it into a worksheet tab. The magic will create a sheet for each employee that will list the lines in the csv which pertain to that employee.

EmpName, Emptask
Sally, talk to charlie
Dave, talk to Andrew
Sally, talk to Robert
Charlie, talk to Andrew

Should end up with 3 tabs, named Sally tasks, Dave tasks, Charlie tasks.
Sally tasks should have 2 lines in it, the others 1 each.

I am confused. The other bug in the works is that I am using Office 2010 (Windows) and I would prefer that this work in MacOffice 2008.

Thanks for any and all suggestions.

 

[Gary's Student]

Use this as a model:

Sub marine()
Dim I As Long, v As String, sh As Worksheet
Dim N As Long
'
'     make the tabs
'
Workbooks.Open Filename:="C:\TestFolder\x.csv"
Set sh = ActiveSheet
For I = 2 To Cells(Rows.Count, "A").End(xlUp).Row
    sh.Activate
    v = Cells(I, 1).Value
    If SheetExists(v) Then
    Else
        Sheets.Add
        ActiveSheet.Name = v
    End If
Next
'
'     croupier the data
'
sh.Activate
For I = 2 To Cells(Rows.Count, "A").End(xlUp).Row
    v = sh.Cells(I, 1).Value
    N = Sheets(v).Cells(Rows.Count, "A").End(xlUp).Row + 1
    sh.Cells(I, "A").EntireRow.Copy Sheets(v).Cells(N, 1)
Next
End Sub




Function SheetExists(strWSName As String) As Boolean
    Dim ws As Worksheet
    On Error Resume Next
    Set ws = Worksheets(strWSName)
    If Not ws Is Nothing Then SheetExists = True
    'Boolean Function assumed To be False unless Set To True
End Function

 

[Blastphemist]

I'm definitely in the right place! After changing some things because my real data is different, I have done it. Thank you so much!

Next question, is it a simple thing to (instead of looking at a external file) look at a tab? My dream is to have this be a template (read only) into which a person would paste the contents of the csv, and the macro would auto-spawn the worksheets. My gut says it can happen, but I don't know any of the commands.