How do i add a drop down in Live Office & return query d

other Live Office
1

Hi Guys,

I have setup a webi query returning two measures, e.g.

Measure 1 - List of office names.
Measure 2 - Number of customers at office.

Can someone please tell me how I go about in excel (Using the Live Office connection) inserting a drop down menu which lets you choose measure 1 (E.g. Office name) in Cell A1 and then once you choose an office it will then return Measure 2 (e.g. the number of customers at this office) in Cell A2.

Hope that makes sense.

I’ve used the search function, and couldn’t find anything.

thanks for any help!
:smiley:

ladiesman217 (BOB member since 2013-01-29)