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 ddalgleish@contextures.com

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:

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.


Contextures Products

Save time with our "Done For You" Excel products.


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




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.