Excel With VBA

The IT department at most companies installs the MS Office suite on an employee’s computer without Access, but MS Access is a “specialty item”, and has to be requested as a separate install. Since some folks don’t have the Access program, but they have Excel, in this post I am going to convert my Access…

Hi Reader, This post will show you how to add subtotals on a variable group by column and total column, and it will also show you how to add some color to the subtotal rows to make them stand out. Here is what the data to which we want to add the subtotals looks like:…

This post is in response to an email question I received. Basically the person wanted to open an Excel file on their network using a command button in their application. From a button or a shape on your worksheet: …assign the following macro (VBA) code: This code opens any type of file with the program…

Macros are used to make frequent tasks automated and easier. If you need to add a column to your Excel worksheet on a daily basis, just record a macro that adds a column. Or, you may need to update the sales reports you receive from the various locations your company does business in. So you’ll…

This code with use VBA to create sheets based on a list of names. In the following image, we have a data sheet listing names in column B. We want to create sheet names based on the names in that column. Make sure your Excel spreadsheet is saved as an .xlsm and accepts macros. In…

In column A we have a list of random names Our task is to divide the list of names into first and last names We are going to parse (divide) the names by using the VBA “split” function. Then we will use the VBA Trim function to remove the excess spaces. We will use a…

Remember the K.I.S.S principle, “Keep It Simple Stupid”. reference: https://hackernoon.com

Here is the scenario, the boss comes in to you, and wants you to add the new cities you all did business in last month to your master list. You are to send the new list to the marketing department, so you all can market to the new cities you did business in last month.…

In this post I am going to show you all how to delete rows with the length of the value in column “A” less than 2. The first way is the not VBA way, and it will be first to determine the length of the cell value using the “len” function: After, you get all…

In this post, we will loop a list of bank account transactions, and copy them programmatically to another sheet based on their date. Here is an image of the sheet: In the account ledger, we are going to loop the rows in the “Full Bank Statement” sheet, and extract only the rows that fall within…