Creating new tabs for each item in the filter of a pivot table

[pedros2310]

Hi All,

This has had me stumped all day and was hoping somebody could steer me in the right direction.

I have a telephone bill (list of calls) where I need to create a separate tab for each users calls.

I have created a pivot table and used the "Show report filters pages" option which gives a separate pivot for each user but I need the data behind it rather than the pivot.

Can anyone help with a macro that would do this?

Many Thanks

 

[My Aswer Is This]

Where on the sheet are the user names?
Which column?
What is the name of the Master sheet?
Do you need to copy the header row Row(1) copied to each new sheet?

 

[pedros2310]

Username is in column D. The data is in columns A-P

The master sheet will have a different name each time as I will need to run this on a regular basis.

Yes I will need the headers in each sheet

Thanks

 

[My Aswer Is This]

Now that you say this will done more then once that leads to more questions:

Are we creating new sheets for each username each time?

So the first time a new sheet is made for 'Mary" " Bill" and "Jane"
And all their calls are logged into their sheet.

But next time we run the script if "Mary" has made a call do we need to make a new sheet for "Mary" of append the new call "Mary" made to "Mary" sheet.

Or have you already made all the sheets needed and we just append each time to the proper sheet.

And can we copy over the entire row or Just columns A to P ?

 

[pedros2310]

Yes it will be a new sheet each time. Usernames could be different each time we run it or some users may have made no calls. I only need sheets for the active users each time.

This can either be on tabs in the source workbook or each user with their own workbook, whichever is easiest.

If it is the latter then ideally will need be saved in a folder which is named the same as the source workbook and each file named as per the username.

The whole row can be coppied. There's just nothing past column p