Creating Single or Multiple Workbooks From Specified Data in Excel

Hi

I would like to ask for your assistance and expertise in providing me a macro to solve the following.

I have an excel containing multiple accounts on it and I would like to create a button that when I click it, it will create new workbook or workbooks separating each account name Appraisal, Bankruptcy, Litigation etc. Meaning from an excel containing all the account name, it will produce a new workbook containing only the Appraisal, and another workbook for Bankruptcy etc. If the excel contains only Appraisal, then only one workbook will be created. The width for each column should always be fit. Then from there, I will be the one to save it to CSV.

Attached is an example of the file for your reference.

Hoping to hear from you.

Thanks,
Marlon

Hi PaulM100,

The code is so amazing. I am so happy to see the results. However, the output for the last row is empty. It does not show any contents unlike with appraisal, bankruptcy and REO Home. Aside from that is that when I add a button on A1, the results or output also show the button. Can I request if you can make some adjustment on the code?

Thank you so much for your time and effort and hope to hear from you soon.