• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Where does dashboard get this value?

See attached sheet called "Dashboard"
See the country dropdown (around cell E25).

Choose a country !
Now, whatever "Country" you chose will UPDATE cell Calculation!B2  (i.e. in sheet called "Calculation").

How does this update happen since this cell does NOT have a formula.

Patrick O'Dea
Patrick O'Dea
  • 2
1 Solution
Hi, 21Dewsbury.

Right-click on the dropdown and select "Format control...". On the"Control" tab, the Cell Link is Calculation!$B$2 - this is what updates the cell. Please see below..

Patrick O'DeaAuthor Commented:
Thx. I live and learn
Thanks, 21Dewsbury. (Pretty good motto!)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now