Hi Amanda You haven't specified at what stage you are stuck with your macro or attached the workbook.
The correct way to go would be 1) Confirm if names are repeated in the source sheet 2) Loop through the column containing the names. 3) Go on adding and renaming sheets and pasting the specific row from the source sheet to an empty row next to the used range! . . . ... pls attach your workbook!! :) Hemant Hegde On 7 June 2010 09:59, Amanda <propagan...@gmail.com> wrote: > Hi all, > > I'm stuck on a macro I'm working on. I'm uploading an example sheet. > > I have a list of data - the first column has the person's name - each > person can have any number of rows. > > I need the macro to create a new tab with the name of the person > (which is the entry in the 'A' column) and and to copy over all of the > rows for that person. In the end I want the first page with all the > data, and then a tab for each person with their data in it. It would > be safest to copy the entire row - the number of columns with data may > change. > > Thanks, > Amanda > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe