<div>
Hi Roy,<br />
<br />
Many thanks for this. &nbsp;Have used the code that you provided, made a few edits to suit my file, and it worked perfectly. Thank you very much! <br />
<br />
<br />
Best regards,<br />
Amber Fortuno
</div>


Hi Roy,

Many thanks for this.  Have used the code that you provided, made a few edits to suit my file, and it worked perfectly. Thank you very much!


Best regards,
Amber Fortuno

<div>
The code that was provided has comments that made it easier for me to modify the code to fit my template.
</div>


The code that was provided has comments that made it easier for me to modify the code to fit my template.

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I'm new to macros and I'm enhancing this report of mine for efficiency. I was able to create the 1st two modules (for formatting and some computations). This is for the 3rd module and for the final step.<br />
<br />
The scenario goes like this:<br />
1. I have a source file (Working file.xlsx). This would be the result from the formatting by the 1st two macros that I have.<br />
2. Column I will be the basis of the number of new workbooks that will saved. So, column I will be filtered and whatever is in it will be saved as a new workbook.<br />
3. The filename is custom for every filtered value. Let's say the values in column I are A, B, and C, the filenames are Apple.xlsx, Banana.xlsx, Cherry.xlsx. (wondering if I could use a lookup table for this one)<br />
4. I'm using Excel 2016, 64-bit.<br />
<br />
Hope you could help me with this one. Thanks in advance!
</div>
</div>


Hi guys,

I'm new to macros and I'm enhancing this report of mine for efficiency. I was able to create the 1st two modules (for formatting and some computations). This is for the 3rd module and for the final step.

The scenario goes like this:
1. I have a source file (Working file.xlsx). This would be the result from the formatting by the 1st two macros that I have.
2. Column I will be the basis of the number of new workbooks that will saved. So, column I will be filtered and whatever is in it will be saved as a new workbook.
3. The filename is custom for every filtered value. Let's say the values in column I are A, B, and C, the filenames are Apple.xlsx, Banana.xlsx, Cherry.xlsx. (wondering if I could use a lookup table for this one)
4. I'm using Excel 2016, 64-bit.

Hope you could help me with this one. Thanks in advance!

VBA - Saving multiple files (with custom filenames) based on filter value

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.