Brilliant function to split data to new worksheets.
Sometimes inconsistent naming of the sheets when selecting "Values of Column" as new worksheet name. Reverts to "Sheet 1" etc.
What is the rule that determines this?
Are there any workarounds so that the split data is named the value of the column each time?