I am trying to split the data in my file into multiple sheets based on a single column. I can find plenty of solutions to do it with VBA but for my data in paricular it throws up a problem, as some of the sheets process fine, but others are blank.
Every solution I can find renames the new sheet with the unique value from the column that generates it, but some are just blank and the sheet has a default title (Sheet5, Sheet6 etc.) Some of the values in the column are quite long which I think causes the problem, as sheet titles can only be 31 characters long. Is there a way of doing it that doesn't rename the sheets so it can just split the data?
Every solution I can find renames the new sheet with the unique value from the column that generates it, but some are just blank and the sheet has a default title (Sheet5, Sheet6 etc.) Some of the values in the column are quite long which I think causes the problem, as sheet titles can only be 31 characters long. Is there a way of doing it that doesn't rename the sheets so it can just split the data?