Hi, i want to sort & copy data to different users sheets, there is about 350 accounts, where i need to sort the data and add them into their sheet with Names, numbers addresses etc. so i made the vba create several sheets named after the names on the list. But i have no clue to how i sort on names, and apply the data belonging to each person. The sorting should be based on the names in the cells. I know how to copy to another sheet using the simple:
VBA Code:
[LIST=1]
[*]Sheets("Ark1").Range("A2:G2").Copy Destination:=Sheets("Sheet2").Range("A1")
[/LIST]
