I need a quick way to create a filter by month on an autofiltered range. Right now I'm manually entering this: That's tedious. One option is to create another column with just the month and year in it and filter on that, but I don't like my data cluttered. So I wrote this [...]
Hi everyone,
I have had a Dutch article on XML and Excel on my site for quite some time now, but never got round to translating the thing into English.
Well, yesterday I found a bit of time during a long train-ride, so here it is:
XML And Excel
From the intro:
Microsoft Office 2003 Professional was the...
Hi all
This week I create a small Add-in to add a few options to the contextual Table Tools tab.
This is a start and love to have feedback what you miss or like to see in a add-in like this.
This are now the options in the Add-in
1) Turn AutoFilter On or Off
2) Clear Filter of the [...]
Hi all
If you create a dictator application in Excel 2007 you maybe want to disable the
shortcuts to the old Excel 2003 menu items in Excel 2007.
I create this page with example code to do this.
Note: There is no test on this moment to see if a tag is already used.
http://www.rondebruin.nl/acceleratorskeys...
At some point in the future, we’re going to look back at the stock market during this financial crisis. If we take a broad enough view, we’ll see something like this: If you move your long-term common stock investments into money market accounts (basically cash) now, you’ll probably...
When Excel is in the news, it’s never a good thing.
via Above The Law
According to the various affidavits (posted below) the Cleary first-year did not notice that the 179 contracts were marked as “hidden” in Excel, and certainly didn’t notice that those entries became “un...
Sorry no Excel posts lately. I thought I’d give you a quick update on what’s happening.
The Texas trip was canceled due to Hurricane Ike. If I had flown Frontier I could change my ticket for nothing. Instead, American Airlines is going to charge me $175. I honestly don’t know how these...
Thing the first: Today I leave for Austin, Texas for golf and to watch UT v. Arkansas. There is some doubt about the latter (and some doubt about which day I’ll be coming home) because a certain hurricane is going to give Texas the Tina treatment.
Thing the second: Jon Peltier said he [...]
Do you read blogs in an RSS reader? If so, I've compiled the ultimate list of Excel RSS feeds.
Currently, it's a list of 29 Excel-related blogs that have RSS feeds. To save you the trouble of subscribing, there's also an OPML file that you can download and import into your RSS reader to create...