This repository contains a series of Visual Basic for Applications (VBA) methods created to streamline and automate tasks in Excel, specifically developed for use in a sales environment at AutoHelp.

Arg1 Required Variant Settlement - the Treasury bill's settlement date. The security settlement date is the date after the issue date when the Treasury bill is traded to the buyer. Arg2 Required ...

Want to learn how to perform Fuzzy Matching with VLOOKUP in Excel? We’ve got you covered. Sometimes, we want to find things that are kind of similar but not exactly the same. This is what we call a ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...