I was wondering how this might be replicated on a table that already has selections applied? When I run this macro it seems to go through and create it's own selections, however, if I have selections already applied to a table/chart I'd like to be able to export that and do something similar to this.
Re: Export to Excel - Multiple Sheets over Dimension
Not quite sure what you mean. If I select B&C and export, I get an Excel file with B and C in different sheets. Do you want to keep the original selection after completing the macro? In that case you could create a bookmark in the macro before looping over the values, and recall it after finishing before dropping the bookmark.
I modified the macro quickly. See attached example.