Connecting two pop-up menus

Perhaps, using same scripting, but I suspect not. Pop up menu cells don't respond to formulas.

You could accomplish the same results using a single menu though. Unfortunately, my first attempt at this indicated there is a 16 item limit, and 12 months + 4 Quarters fills all available item spaces in a popup menu, so you would not be able to include a "none" item to show a blank space when nothing has been selected.

But shortly after that, when I had added a column to the table (which contained a copy of each of the constructed menus), all 17 menu items were selectable and displayed as would be expected, including the blank for 'none'

Here's the 16+"none" menu:

Regards,

Barry

Should the above not work, you could use a pair of pop-up menus plus a cell to pickup the result from the menu showing a non-blank result.

Here's an example showing the four possible patterns of choice and the results, in column F of the choices made in the two popup menus i column E.

The formula shown is in the selected cell (F2), and has been copied from there and pasted in to cells F7, F10, and F15.

Regards,

Barry

Why not have a popup to select the month and use a formula to determine the quarter? Are all months fully in a specific quarter or, for example, would July be partly in Q2 and partly in Q3?