This repository contains two Visual Basic for Applications (VBA) macros designed to automate specific tasks in Excel. These tasks include validating and categorizing student data (ExcelsiorMacro1.vb
) and exporting data for further processing (exportData.vb
).
- Microsoft Excel (The macros are tested on Microsoft Excel 2016 and later versions)
- Basic understanding of VBA and Excel operations
- Open Excel and navigate to the workbook where you wish to implement these macros.
- Press
Alt + F11
to open the VBA Editor. - In the VBA Editor, right-click on
ThisWorkbook
under Microsoft Excel Objects in your workbook's project. ChooseInsert
>Module
to create a new module. - Copy the content of
ExcelsiorMacro1.vb
orexportData.vb
and paste it into the newly created module. - Close the VBA Editor and return to Excel.
This macro automates the process of checking and categorizing student data based on specific criteria such as student type, break in study, and credit requirements. It is triggered automatically when changes are made to relevant columns in your worksheet.
- Student Type First Semester Freshman: Updates the Decision Column based on the "First Term Freshman" status.
- Break in Study: Flags students who failed due to a break in attendance.
- Credit Requirement Check: Categorizes students based on their credit fulfillment.
This macro facilitates data export tasks. It filters pending data, saves it into a "Pending Verification" file, and creates a "Data to Send" file with necessary columns and formatting.
- Ensure the worksheet from which you're exporting data is properly formatted and contains the required columns.
- Add a button (Insert > Shapes > Action) and assign the
ExportData_Click()
macro to it. - Click the button to run the macro. It will create new workbooks for "Data to Send," "Pending Verifications," and "Master File" as per the configured criteria.
Contributions are welcome! If you have improvements or bug fixes, please follow these steps:
- Fork the repository.
- Create a new branch (
git checkout -b feature-branch
). - Commit your changes (
git commit -am 'Add some feature'
). - Push to the branch (
git push origin feature-branch
). - Create a new Pull Request.