trip_to_tokyo
New Member
- Joined
- Dec 17, 2009
- Messages
- 13
Continuing to work down page 225 of Pivot Table Data Crunching for MS EXCEL 2007.
Point number 2 on that page states:-
"Activate the Forms toolbar and place a combo box onto your spreadsheet"
Fine, I have done that.
Now it goes on to say:-
"3. Create a hard-coded list of all the markets that exist in your pivot table."
What the book fails to state is HOW to do this.
Can anybody assist here please?
Column E of my underlying data for the Pivot Table is called:-
Market
Thanks in advance for any replies.
Point number 2 on that page states:-
"Activate the Forms toolbar and place a combo box onto your spreadsheet"
Fine, I have done that.
Now it goes on to say:-
"3. Create a hard-coded list of all the markets that exist in your pivot table."
What the book fails to state is HOW to do this.
Can anybody assist here please?
Column E of my underlying data for the Pivot Table is called:-
Market
Thanks in advance for any replies.