Tag: excel

Excel is how I do maps…

Following the footsteps of this cool post I saw by JohnNelsonIDV, I wanted to try to and make a map using Excel. Fast forward 2 days and the opportunity came up. Lo and behold, a Map of Reference Evapotranspiration built in Excel! Instructions: Read data file into Excel (skip top rows with metadata), make sure to delimit correctly so that each… Read more →

kml maker for Excel -> Google Earth

I made a userform that quickly and easily allows you to make a kml file that’s readable by google earth based on some excel dataset that has coordinates. Features: Simple and advanced modes userform for convenience Icons change when highlighted Allows html to be passed to popup contents, everything is customizable Issue a default icon, and change icons for specific… Read more →

Compare lists and identify matches macro

This macro provides an alternative to vlookup (which looks at two lists and provides data from one list to the second) that retains similar functionality while providing certain benefits. It accomplishes this by physically moving one list to the other. It’s impossible to get a false positive, and it doesn’t provide that annoying #N/A that messes up calculations. Additionally, it… Read more →

Macro userform – a good visual way to organize macros

At a certain point it can become challenging to quickly find and run the macro we need. Below are some options to organize our macros. I will focus on using a pop-up form because it’s the method I prefer, but at the bottom of the article, you can see other options. A pop-up menu looks like this: How to make your own… Read more →

%d bloggers like this: