Hi,
The macro as follow will create a tab for each row in column A, in the macro
the list is in sheet2 change it for your sheet name, and the range mine is
from row 1 to 88

Sub Add_NameWS()
'Add and name sheets using
' list in A1:A88 in Sheet2
For i = 1 To 88
Worksheets.Add.Name = _
Worksheets("Sheet2").Cells(i, 1).Value
Next
End Sub



"Richard" wrote:

Is it possible to split data from one worksheet to seperate worksheets based
on a criteria in Column A, e.g. day / month / surname / etc.

I have a master list of data which changes frequently and it is split into
seperate worksheets for individuals to review data specific to them. I want
to automate copying the data from the master schedule to the seperate
individual worksheets.

Thanks.
--
Richard