I have a workbook that brings together data from a myriad of places and eventually puts together a number of worksheets one for each country that I am working with.
What I would like to be able to do more easily is to highlight all my country worksheets - [I can do this bit manually] and then save them as individual workbooks each called [TAB].xlsx ie United Kingdom.xls in the same folder as the current workbook.
Is this possible using VBA or some other means.
Currently each week, I am right clicking and copying the tab to a new workbook then saving, 32 times and its getting very laborious.
What I would like to be able to do more easily is to highlight all my country worksheets - [I can do this bit manually] and then save them as individual workbooks each called [TAB].xlsx ie United Kingdom.xls in the same folder as the current workbook.
Is this possible using VBA or some other means.
Currently each week, I am right clicking and copying the tab to a new workbook then saving, 32 times and its getting very laborious.