Split workbooks by a column value

Hi GurusView attachment TEST DATA1.xlsxView attachment CODE.txt,

Need Your help i have spreadsheet with around 20 columns i need a code to split it based on the Column A (clusters) and save the excel based on the cluster name.

i have code for the same however on the code i have criteria for column L however i need the code to split based on column A. Please help to change the code.

Thanks

Aravind

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see our rules about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Hi,

Apologies for the inconvenience.

I have posted the query in excelguru forum.

Please find below the link.

https://www.excelforum.com/excel-pr...e-file-according-to-clusters.html#post5230861

Apologies once more will provide the link goingforward if i post the query in other forum.

Thanks

Aravind