Splitting Data from One Worksheet to Many Automatically

[Richard]

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.

 

[Eduardo]

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

 

[Pete_UK]

Yes, it is possible to do this. You could use formulae, but you would
need to fix the values within each of the subsidiary sheets before
sending them off to individuals. If you are doing this frequently it
might be better to use a macro.

Either way, you would need to supply more details of what data you
have and exactly what you want to do with it.

Hope this helps.

Pete

 

[Richard]

Thanks Pete.

Without going into too much detail Column A would have categories such as
W01, W02, W03 etc, There would be many rows for each category. I just need
to know how to write a macro to remove or copy all rows with W01 into a
worksheet called W01 (with the macro also creating the worksheet), and then
does the same for W02, W03 etc. The worksheet that contains the full list of
data would be called Summary.

Thanks,
richard