macro for Multiple Filters

[BRRLL99]

Hi

I have Following Data from A to Z

At present I'm using multiple Filters to split records based on names starting with Alphabets , I would like create separate files in excel based on names

data

Mani

Mani

Ashok

Ashok

Ashok

Ashok

Balu

Balu

Balu

Cement

Cement

Dhruva

Dhruva

Dhruva

At present I'm using this formula and multiple filters

[Qiu · Accepted solution]

@BRRLL99 
I think this is a good application senerio for "Take file/table name from field" option for the Output tool.

Simple in below.