Excel Macros Collection

This repository contains a collection of useful Excel VBA macros for automation and productivity enhancement.

Available Macros

SplitTextToColumns

Splits text in cells from column A into individual characters across columns. This is useful for processing text data that needs to be broken down character by character.

Primary Use Case: EFT File Validation

This macro was primarily created for validating the characters and values in Electronic Funds Transfer (EFT) files exported from various systems. It helps ensure compliance with banking standards such as:

Australian EFT requirements
NACHA (National Automated Clearing House Association) formats
ANZ/ANZ banking formats

By splitting text into individual characters, financial professionals can easily validate that each position in an EFT file contains the correct character type and value according to the required specifications.

How to Use

Enable Developer Tab:
- In Excel, go to File > Options > Customize Ribbon
- Check "Developer" in the right panel and click OK
Import a Macro:
- Open Excel and press Alt + F11 to open the VBA editor
- Right-click on your workbook in the Project Explorer
- Select Import File and choose the .vba or .bas file
Run a Macro:
- In Excel, go to the Developer tab
- Click on Macros
- Select the macro you want to run and click Run

Sample Files

The Samples directory contains example Excel files that demonstrate how each macro works.

Future Plans

This repository will be updated with additional macros to enhance Excel productivity.

Author

Jeffrey Bulanadi

Last Updated

May 16, 2025

License

jeffreybulanadi/excel-macros-collection

ErrorLooks like something went wrong!

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages