A couple of years ago, a colleague at work was having a devil of a time with an Excel file. It did something with data and dates, I don’t really remember what. What I do remember is that the data was an extract from a separate system, and then that export was dropped into anContinue reading “Excel Geeking: Finding Those Pesky Hidden Characters”
Category Archives: Excel
Excel Geeking: Removing All Empty Sheets using VBA
You ever need to go through a workbook you’re working on and delete a bunch of sheets that have nothing in them? Maybe you’re creating a new automated report that requires you to plunk down a large chunk of data in a new workbook, but when you create that new workbook, it creates it with “Sheet1”Continue reading “Excel Geeking: Removing All Empty Sheets using VBA”
Excel Geeking: When List Object Columns Attack, or Why Won’t This Calculated Column In My List Object Table Calculate Anymore
I know the title of this post is too long. But it captures the essence of what I’m trying to figure out. I’m sure this has happened to someone else, and maybe even someone else who has figured out how to correct it. If you have, let me know, leave a comment below, send aContinue reading “Excel Geeking: When List Object Columns Attack, or Why Won’t This Calculated Column In My List Object Table Calculate Anymore”
Excel Geeking: Extracting Comments Using VBA
A couple of months ago a colleague moved into a new position at work and inherited a big ugly spreadsheet. Happens to the best of us, amiright? The biggest challenge with this spreadsheet is that the previous owner, who has since retired (and good for him!) didn’t update his status notes and comments in aContinue reading “Excel Geeking: Extracting Comments Using VBA”
Excel Geeking: Using Special Characters in ListObject Column Names in VBA
This is a short one, but a REALLY specific one. Recently (i.e., today) I was tinkering with some List Objects, a.k.a. “tables” in VBA. All I was trying to do was to clear the contents of a column. Easy enough. It looked something like this: No Excel love. It kept throwing me an error. Specifically, errorContinue reading “Excel Geeking: Using Special Characters in ListObject Column Names in VBA”
Excel Geeking: Extracting Outlook Address Book Information To Excel Using VBA
Yeah, I know there are a lot of posts out there about this already. So here’s another. Truth be told, when I first went searching for items on this topic, I couldn’t find what I was looking for. Granted, it’s not outside the realm of possibility that I simply suck when it comes to a decent GoogleContinue reading “Excel Geeking: Extracting Outlook Address Book Information To Excel Using VBA”
Excel Geeking: Counting Recurring Instances of the Same Value Using a Formula
A coworker of mine, who works in another department, had a spreadsheet her group uses to manage what gets pushed out to the stores and when. If you’re in retail, and retail IT especially, you know you don’t mess with the stores anymore than necessary. They are the moneymakers, and you don’t want to beContinue reading “Excel Geeking: Counting Recurring Instances of the Same Value Using a Formula”
Excel Geeking: “That Command Cannot Be Used On Multiple Selections” Error On A Single Cell
UPDATE (18-FEB-2015): Remember this? Yeah, unfortunately I do too. I wish I could say that my update from September was the end of the conversation. Sadly, it wasn’t. I started getting this error again and there was no random PowerPivot data connection in my workbook. When I saw it pop up again, I was absolutelyContinue reading “Excel Geeking: “That Command Cannot Be Used On Multiple Selections” Error On A Single Cell”
Happy International Keyboard Shortcut Day
Happy International Keyboard Shortcut Day. Never heard of it? Yeah, neither had it. That’s likely because Dick Kusleika over at Daily Dose of Excel made it up. Read more about it here. Basically, the idea is to use only your keyboard as much as possible between the time of 2:30 and 3:30 PM local on this,Continue reading “Happy International Keyboard Shortcut Day”
Excel Geeking: Unwinding a Crosstabbed Dataset
Sometimes you have to work with a data set that is not in a state conducive to, well, anything. I’m thinking specifically about crosstabbed data sets. More than once I’ve had to deal with a data set that looks like this: Oh, if only there were a way to unwind this file so that it wasContinue reading “Excel Geeking: Unwinding a Crosstabbed Dataset”
Scott C Lyerly 