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 firstname.lastname@example.org
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
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
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
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.
Here are a few of the Excel articles that I read last week, that you might find useful:
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..
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.
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.
Contextures Inc., Copyright ©2017
All rights reserved.