Hello everyone,
I'm currently working with a few Pivot Tables that will be double-clicked on by a few people on the results, which by default, Excel will generate a new worksheet with the data within those same results.
What I would like is, instead of generating a new worksheet, to generate a new workbook with that data, and name it with the selection's name.
I have my fair share of VBA knowledge, and I believe I can create a complex code, in which on the double-clicking action or the new worksheet generation (and based on the name of the new worksheet), I would then copy all the data of that new worksheet, create a new workbook with a specific name, past all the data into the new workbook, and then with a simple code to automatically clear out the new worksheets generated that way... But I think there's a much simpler way to do what I need to happen, just needing some help in the right direction :D.
Kind Regards,
Cedric Martin
I'm currently working with a few Pivot Tables that will be double-clicked on by a few people on the results, which by default, Excel will generate a new worksheet with the data within those same results.
What I would like is, instead of generating a new worksheet, to generate a new workbook with that data, and name it with the selection's name.
I have my fair share of VBA knowledge, and I believe I can create a complex code, in which on the double-clicking action or the new worksheet generation (and based on the name of the new worksheet), I would then copy all the data of that new worksheet, create a new workbook with a specific name, past all the data into the new workbook, and then with a simple code to automatically clear out the new worksheets generated that way... But I think there's a much simpler way to do what I need to happen, just needing some help in the right direction :D.
Kind Regards,
Cedric Martin
