Hello all,

Not sure if this is possible, I currently have code that will take each item name visible in a pivot table field and name the sheet after each pivot item name. I am trying to come up with code that will move each of the created sheets on to a separate workbook using the move function. The problem is that i would need to use an array formula in order to move the sheets efficiently. Has anybody out there done something similar? My brain is fried as far as figuring out how to do this.

Hello,

Why don't you create them directly in the separate workbook rather than creating them in the same workbook and then moving them? Why do you need an array formula to move the sheets efficiently?

The problem I was having with that is going back and forth between the parentworkbook and the newly created workbook as the calculations in the new workbook were based on pivot tables located in the parent workbook. I also felt it would be more efficient to move the sheets that needed to be moved all at once as opposed to one at a time. This is what I have so far, not quite what I wanted, but it works:

This was based on code I found on OZGrid.com. If anybody knows of a more efficient way, i'd be more than inclined to listen.