A Simple Trick for Referencing Data Between Worksheets In Microsoft Excel

A Simple Trick for Referencing Data Between Worksheets In Microsoft Excel

May 7, 2013 · by · in

I don’t work in Microsoft Excel often, and when I do, the documents tend to be pretty simple. Most of my work with Excel involves collating tabulated data and then publishing it a a Web-compatible format (the HTML

still has its uses). I’ve never had any actual training in Excel (or any other spreadsheet software), but I’ve picked up enough to do the job at hand, and every now and again, I pick up a trick that makes working with data across Excel worksheets much easier.

Troubleshooting As A Development Technique

Troubleshooting As A Development Technique

April 26, 2013 · by · in ,

Pretty much all of my development activities start out with the question: “Can the website (or PC, or Smart Phone or toothbrush) do this form me?”

Broken Background Images In Internet Explorer

February 4, 2013 · by · in ,

I should take it for granted that I’m going to have to resort to some sort of chicanery to get my CSS to work in Internet Explorer. Today, my background images weren’t appearing in certain elements on IE but were…

Simple Way to Get a Domain from an Email Using T-SQL

December 20, 2012 · by · in ,

One of my recent projects required me to create a Microsoft SQL Server view that displayed (among other information) and email address and its underlying domain. Microsoft SQL Server and T-SQL provide a few simple functions that, when used together, make this a fairly easy task.

Episode I: The Phantom Mini

Episode I: The Phantom Mini

December 18, 2012 · by · in

Over on PaperlessCockpit.com, I’ve been writing about my quest to find an iPad Mini. More than a month later, and I still haven’t been able to track one down in stores that I can actually purchase. Sure, the Apple Store will let me play with a demo unit, but unless I can run faster than the mall cop, I’m not leaving with one.