Hello,

I have an excel file containing a large number of sheets, all of which are named a 6 digit reference number, when there is more than one sheet with the same number it will have brackets and a number in it. eg (2).

For example the sheets will be called something like: 123456 (1), 123456 (2), 123456 (3), 987654 (1), 987654 (2), 987654 (3), 987654 (4). For these sheets I would like to create two files, one called "123456" (containing those sheets) and one called "987654" (containing those sheets).

Ideally I would like this all to be done in the background and saved as marco-free workbooks, without having to be prompted each time on how to save them.

For the save location it can be the same location as the file.

Any help would be greatly appreciated, thanks in advance.