Moved to the Excel Twitters archive:
Excel Twitters 20090529
var fbShare = {size:’small’}

Today’s challenge was to create a table of contents in Excel, for a downloaded price list. The data came from Crystal Reports and had formatting on the section headings. Some of the headings were repeated, but we didn’t want the TOC to include the duplicates.

I’ve created a table of contents based on sheet names, in [...]

Usually when you’re sorting data in Excel, it’s by entries in a column. For example, you might have a list of customer names in a column, with the customer addresses and phone numbers in the adjacent columns.
You can sort the rows by the customer names in column A, and all the address information moves with [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090522
var fbShare = {size:’small’}

You’re probably the Excel guru in your office, and everyone comes to you to solve their Excel problems. But what happens when you have a question, or want to learn a new technique? Do you hunt for answers in Google, read blogs, and flip through books looking for instructions?
Instead of struggling on your own, [...]

Monday was Victoria Day in Canada, which is the unofficial start of summer. However, my tomato plants are huddled in the garage, wearing little polar fleece sweaters, hoping it will warm up soon. It dipped to 1°C last night, but at least it didn’t snow!

Despite the frosty weather, I’m putting the Contextures Blog on [...]

Roger Govier has created a sample workbook and instructions that show you how to create dynamic dependent data validation lists. His technique lets you create multiple levels of dependent data validation, without defining a named range for each list. Instead, Roger’s formula uses the INDEX function, with MATCH, to find a column heading, then shows [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090515
var fbShare = {size:’small’}

If you’re eagerly awaiting the next release of Microsoft Office, you can find some early information at the new official Office 2010 blog.  There’s not much news there yet, but you can subscribe to the RSS feed and read any updates as they’re posted.
Also, there’s an Office 2010 web site, where you can apply to [...]

In Excel, you can create a drop down Data Validation list, using a list from another workbook as the source.

However, for the data validation to work, the workbook that contains the list must be open, in the same instance of Excel. Users will have to open both the workbooks — the one with the drop [...]