Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Excel Weekly News from Contextures Jan 28, 2014

Pivot table filters + more Excel tips

In this week's Excel news, you'll see how to apply multiple filters on a pivot field, and other tips. Thank you for reading the Excel news!

 -  Debra

Multiple Selection Drop Down With Codes

There is a sample file on my website that has VBA code for selecting multiple items from a data validation drop down list. You can insert all the selected items into the active cell, or down the adjacent column, or across a row.

I've updated the file to insert matching codes into the adjacent cell. So, if you select three products, their codes would appear in the cell to the right.

Click here to see the details, and watch the video: Multiple Selection Drop Down With Codes

Apply Multiple Filters on a Pivot Field

By default, a pivot table is set up to allow only one filter per field -- Label, Value or Manual. However, if you want to use more than one filter per field, you can change one of the Pivot Table options.

Click here to see the details: Apply Multiple Filters on a Pivot Field

Calculate Survey Scores with Option Buttons

Set up a survey forms, with option buttons to select an answer. For scoring, use the default value of each button, or build a lookup table with your own scores. The sample file has a macro that sets up the survey, similar to last week's macro for check boxes.

Click here to see the details: Calculate Survey Scores with Option Buttons

Excel Dashboard Reminder

Just a reminder that registration for Mynda Treacy's Excel Dashboard Course closes on January 30th.

I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there’s even an option to download the videos.

Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of my time-saving Contextures Excel Tools add-in. Just enter the Referral Code – DebraD – in the box just below the Buy Now button.

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

  • And finally, for a humorous peek at what other people are saying about Excel, read the weekly collection of Excel tweets, on my Excel Theatre blog.

Video: Show a Warning Message Before Printing

Laste week, we saw how to show a warning message in your Excel workbook by using a macro. This video explains how to automatically show a message, before a sheet is printed..

Shells on Shells

Some days the beach is smooth, with only a few odd shells or bits of seaweed. The day that I took this picture, thousands of tiny shells had washed up onto the beach, with a few larger ones perched on top.


Recommended Excel Tools

In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2014
All rights reserved.