Hi,
I'm trying to find a quicker way to do a work task but as my VBA skills are rudimentary I don't know if it is possible to do or not.
Essentially I have a file with multiple tabs (example names 'KB123 X, KB123 Y, KB123 Z, KB456 Y, KB456 Z etc) and what I need to end up with are separate files, one of which has all the KB123 sheets, another with all the KB456 sheets etc, named in a specific way (e.g. combined KB123 Month). There are probably in the realm of 100 sheets, needing to be split into about 20 files but there are different numbers of sheets for each ID code. Some of the sheets I don't actually need at all but as those have a different ID codes to the ones I do need I figure I can just delete the files for those afterwards.
I have found a macro to separate the sheets into individual files, but as I still would then have to merge them manually that doesn't save me any time on top of the current 'ctrl click on all KB123 tabs, copy into new workbook, save, repeat' that I am already doing.
Any help would be very welcome but please express it in a 'for dummies' way as I am still learning.
Thanks.
I'm trying to find a quicker way to do a work task but as my VBA skills are rudimentary I don't know if it is possible to do or not.
Essentially I have a file with multiple tabs (example names 'KB123 X, KB123 Y, KB123 Z, KB456 Y, KB456 Z etc) and what I need to end up with are separate files, one of which has all the KB123 sheets, another with all the KB456 sheets etc, named in a specific way (e.g. combined KB123 Month). There are probably in the realm of 100 sheets, needing to be split into about 20 files but there are different numbers of sheets for each ID code. Some of the sheets I don't actually need at all but as those have a different ID codes to the ones I do need I figure I can just delete the files for those afterwards.
I have found a macro to separate the sheets into individual files, but as I still would then have to merge them manually that doesn't save me any time on top of the current 'ctrl click on all KB123 tabs, copy into new workbook, save, repeat' that I am already doing.
Any help would be very welcome but please express it in a 'for dummies' way as I am still learning.
Thanks.