automating a pivot table
When using a pivot table, is there any way of
automatically selecting from a drop down menu. By this I mean if I can select one of 5 colours, If I put "red" in cell A1, can the pivot table be made to take the value in cell A1 as the colour selection, rather than me selecting red from the drop down list. thanks in advance |
You can add fields to the page area. When you select from the dropdown
list in a field there, the table is filtered to show only that item. bobf wrote: When using a pivot table, is there any way of automatically selecting from a drop down menu. By this I mean if I can select one of 5 colours, If I put "red" in cell A1, can the pivot table be made to take the value in cell A1 as the colour selection, rather than me selecting red from the drop down list. thanks in advance -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 04:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com