To Hire me for custom Excel and VBA Programming please email email@example.com
Distance Between Zip Codes Calculator in Excel –
Use this tool built in Excel to Calculate Distance between Addresses or Zip Codes from a list of locations. Click a button and the tool will generate the results for you using the Google Maps API.
Convert Addresses To Latitude Longitude in Bulk –
This file takes a list of up to 5000 addresses and converts them into latitude / longitude coordinates in Excel.
Combine Multiple Excel Files into One Master File –
In cases where you get similar data outputs with the same headers, with the click of a button you can combine them all into one file.
Standardize/Validate Business and Residential Address in Excel
Use this tool to Standardize and Validate and Cleanse your list of addresses all within Excel. It uses Google API to process your incomplete or incorrect client list. It works for both commercial and residential Addresses.
Import Folder Contents and File Names into Excel –
By selecting a folder in the file dialog, all subfolders names and file names download into a searchable, filterable hierarchy in Excel.
Track Round Trip Mileage Using Outlook Calendar Appointments –
Simply by putting in an address as your appointment location, you can download your Outlook calendar into Excel and automatically generate your round trip mileage.
Display US Supply Chain / Logistics in Excel –
Excel-based Supply Chain Map is generated using your product starting location and destination. Mileage and travel time for your product is displayed along with a map plotting the volume of goods transferred.
Store Locator in Excel – Find the closest Store for each of your clients –
This Tool allows the user to find the Closest Store (from a list of predetermined locations) for each customer (from a customer list). It can be used if creating servicing assignments (find closest contractor for each client) and many other functions.
Maintain YOUR Do Not Contact Email List in Excel –
This file cleans your email list against the email addresses of people that have requested to no longer receive mail from you.
Maintain YOUR Do Not Call List in Excel –
Compares a list of phone numbers against your list of numbers that you don’t want to call. You must enter the DNC numbers in a separate column.
Maintain a One Time Use Email List in Excel –
After dumping email addresses into a column, this removes email addresses that have already been used and adds the remainder to the list so they won’t be used in the future.
Any of this logic can be implemented in your sheet. Email firstname.lastname@example.org to hire Excel and web programmers.