Dictionary Flagging Macro

Estimated reading time 2 minutes, 34 seconds

One quick thing before we begin, what is a Macro?

An Excel macro is a set of instructions that automate a repetitive or complex task in Microsoft Excel. Think of it like recording a series of actions in Excel, that can then be played back automatically whenever you need to perform that same set of actions again. For example, you could create a macro that automatically sorts a table and applies a specific formatting to the data.

On the other hand, an Excel formula is a pre-built function that calculates values based on the data in cells. It’s like a recipe for performing a specific calculation or operation, such as adding or multiplying numbers. For example, you could use a formula to automatically calculate the sum of a range of cells.

The key difference between macros and formulas is that macros are a set of user-defined instructions that can perform more complex tasks, while formulas are pre-built functions designed to perform specific calculations on data in cells. Macros can help automate repetitive tasks and improve your productivity, while formulas can help you quickly perform calculations on your data.

What CURTIS Digital did

Zebra is a leading provider of hardware and digital solutions, offering a wide range of products and services to clients across the globe. With a focus on security and customer satisfaction, Zebra was looking for a way to quickly scan its Digital Asset Management (DAM) system for internal documents that were publicly accessible. CURTIS Digital was engaged to help Zebra achieve its goals.
The Dictionary Flagging Macro project was designed to parse large amounts of data for keywords that are manageable in a “dictionary” tab. The project involved creating an excel macro that would scan any column of data (filename, title, description, etc.) for the keywords and highlight those rows in a pre-filtered output tab. The CURTIS Digital team worked closely with Zebra to design and implement the macro and test it against thousands of assets.
One of the key benefits of the Dictionary Flagging Macro was its speed and efficiency. The macro was able to process over 10k dictionary items in around 4 minutes, making it a fast and effective solution for Zebra’s security audit needs. Additionally, the macro was flexible and could be used with any columns of data, and the macro would always create an associated “flagged” column in the output to mark where it finds the offending words.
The Dictionary Flagging Macro project was a huge success, delivering a number of benefits to Zebra, including improved security, increased efficiency, and reduced manual effort. The excel macro enabled Zebra to quickly and easily scan its DAM system for internal documents that were publicly accessible, helping the company maintain the security of its data.
Overall, the Dictionary Flagging Macro project was a great example of how CURTIS Digital’s expertise in technology and security helped a client achieve its goals. With a focus on innovation and customer satisfaction, CURTIS Digital delivered a customized solution that drove results for Zebra, helping the company take its business to the next level.

Leave a Reply

Your email address will not be published. Required fields are marked *