top of page
Search
Kimberlee Martin
- Jan 11
- 4 min
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
2 views0 comments
Kimberlee Martin
- Jan 9
- 4 min
Linking Excel to Your Data
Creating links to Microsoft Access data in your Excel worksheet.
6 views0 comments
Kimberlee Martin
- Jan 5
- 6 min
Linking Access to Excel Data
Create a Microsoft Access table that is linked to an Excel file.
8 views0 comments
Kimberlee Martin
- Jan 3
- 5 min
VBA: Three Ways to Handle Text in Numeric Fields
Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.
2 views0 comments
Kimberlee Martin
- Dec 28, 2022
- 5 min
Integrating Excel with your Software Package
Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.
7 views0 comments
Kimberlee Martin
- Dec 22, 2022
- 3 min
Using Access to Clean Excel Data, Part 5
I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that series, and our topic is getting the cleaned data back to Excel. To recap, my premise is this: Microsoft Access has lots of tools that can help you clean up your Excel data. I’ve covered many of them in the last few posts, including the find duplicates query, update queries and several useful functions. Here are links to the other articles in
5 views0 comments
Kimberlee Martin
- Dec 19, 2022
- 4 min
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
7 views0 comments
Kimberlee Martin
- Dec 16, 2022
- 4 min
Double Trouble
Today we’ll be looking at preventing duplicate values from being entered into your Excel sheet. This is the final entry in a series that looked at several ways to ensure that data being entered into your Excel sheet is valid. In this case, we’re going to use a custom validation rule, which we’ve already seen briefly when validating phone numbers. We’ll combine that with the “CountIf” function, so let’s start with a quick overview of that one. The CountIf function allows you t
11 views0 comments
Kimberlee Martin
- Dec 12, 2022
- 6 min
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
5 views0 comments
Kimberlee Martin
- Dec 6, 2022
- 2 min
Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you can leverage to validate any Excel data. Then I covered some phone number validations you might add to that harness. Today I’m going to talk about using that harness to automatically replace text that a user may enter. I consider this part of data validation, because you can use it to head off data issues. Here’s an example: Converting "K" to
6 views0 comments
Kimberlee Martin
- Dec 2, 2022
- 4 min
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
9 views0 comments
Kimberlee Martin
- Dec 1, 2022
- 5 min
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
7 views0 comments
Kimberlee Martin
- Nov 28, 2022
- 6 min
Parse Phone and Extension with VBA
Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file that allows you to add custom validation as users are entering data. Now that we’ve laid that framework, we can work on adding some useful validation. Phone Numbers and Extensions Today, we’re going to look at phone numbers and extensions. When setting up an Excel file, it’s common for people to create a single column that is used for both, as
9 views0 comments
Kimberlee Martin
- Nov 21, 2022
- 6 min
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
15 views0 comments
Kimberlee Martin
- Nov 18, 2022
- 9 min
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
7 views0 comments
Kimberlee Martin
- Nov 16, 2022
- 6 min
Validating a State in Excel
Use Excel tools to validate a U.S. state.
4 views0 comments
Kimberlee Martin
- Nov 14, 2022
- 5 min
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
17 views0 comments
Kimberlee Martin
- Jun 3, 2021
- 4 min
Making the Most of Excel
Ideas for maximizing your use of Microsoft Excel
13 views0 comments
Kimberlee Martin
- May 26, 2021
- 3 min
Check Marks in Excel
Excel is a great tool for helping you stay organized, and many people create checklists in Excel for just that purpose. I’ve got a packing checklist, for example, so that when I go on vacation, I don’t forget any important items. From a business perspective, I have a client in the construction industry, and they use a check list to ensure that key tasks are performed when a job is complete. Their checklist looks something like this: To make life a little easier for them, I wi
23 views0 comments
CATEGORY
ARCHIVE
bottom of page