Combo Box / Hard Coded List
 

I have placed a Combo Box onto my spreadsheet.

How do I create a hard-coded list of all the markets (one of the fields /
columns in my underlying Pivot Table Data).

All I have on the screen in front of me at the moment is:-

- my underlying Pivot Table data

- the Pivot Table

- a large downwards facing arrow (presumably the Combo Box).

Thanks in advance for any help.

Combo Box / Hard Coded List
 

OK, got it sussed.

"trip_to_tokyo" wrote:

I have placed a Combo Box onto my spreadsheet.

How do I create a hard-coded list of all the markets (one of the fields /
columns in my underlying Pivot Table Data).

All I have on the screen in front of me at the moment is:-

- my underlying Pivot Table data

- the Pivot Table

- a large downwards facing arrow (presumably the Combo Box).

Thanks in advance for any help.