Macro New WS for each unique record

[Menu123]

Hi! I am looking for some help creating a macro... I have a file with data in col A-L. The data in col L is a list of names. I'd like to create a seperate worksheet, maybe even a seperate file, for each name. On the new file I'd like to pull over all the data from col A-M (or A-L) for each row. In otherwords, the long way would be to sort by col L and then cut and paste all col for rows 1-10 in to a new file (for example). Can anyone help? I've come close and failed so many times. I am not a VBA expert (barely a newbee) but I am pretty good at recording macros and then altering them in VBA. Any help would be appreciated....even to just get me started Thank you!

 

[Trevor G]

Welcome to the Forum,

What I suggest is create a Pivot table from your data, and when you want to have separate sheets you can use the Page option in Pivot table to get a unique sheet for each name.

It would help to give you more guidance to know which version of Excel you are using!


If using 2003 or earlier version
1. Select your Data
2. Use Tab Menu and Pivot Table
3. Go through the guide and layout the Data how you want but place the names in the Page Option
4. Then use the Pivot Table toolbar to select to Show Pages, and it will create a worksheet for each Name and give you an individual Pivot for each name.

If using 2007 or later version
1. Select your Data
2. Select the Insert Tab and Pivot table (first icon on the left)
3. Layout the data how you want, place the Names in the page option
4. Then select the Options tab
5. Select the Options on the left and in the drop down select Show Report Filters
6. This will give you a unique sheet for each name.

I hope this helps you, no macro needed...