Hi there,

I'm trying to loop through column A on sheet 1 which has a few worker's names on it to create tabs with each workers' names.

Then I want their wages from column B on sheet 1 to appear on each tab under their names with in cell A1, which I believe is another loop within a loop.

Here's my code so far :


Sub Macro1()


counter = 2


Do Until Sheets("Sheet1").Cells(counter, 1) = ""


ActiveSheets.Add = Sheets("sheet1").Cells(counter, 1).Name (I can't work out what is wrong with this line).


counter = counter + 1


Loop




End Sub