Re: $$Excel-Macros$$ Creating new sheet for each person and transferring their data

2010-06-08 Thread Hemant Hegde
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 r

$$Excel-Macros$$ Creating new sheet for each person and transferring their data

2010-06-06 Thread Amanda
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 t