Hi LesleyC

See this page for example code
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"LesleyC" wrote in message ...
I need a macro or VBA to Copy Same Rows Data in A:A into their own Worksheets with the same row name.

From a list in column A in sheet1 that has the multiple rows of same name and I want to creates a worksheets named by that row
name. Names are always A,B,C



Example:
Worksheet SHEET1

a

a

a

b

b

b

c

c

c


(save worksheet: sheet1)



Worksheet: a Worksheet: b Worksheet: c

a b c

a b c

a b c