Create A Dynamic Reference To A Worksheet
Sometimes you want to reference a worksheet dynamically in a formula, so it can be easily changed. In this workbook we have five weeks of test scores, each in the same format. Let’s assume we want to build a simple dashboard that shows the Maximum score, the Minimum score, and the Average score for whichever worksheet a user selects. We’ll take this one step at a time. First, let’s just add the formulas we need and hardcode a reference to a single worksheet....