I’ve attached a version of my spreadsheet as an example, with just 5 contracts being reported. My actual report will have approximately 40 contracts.
I’ve added a drop down box list each of the 5 contracts being reported in the spreadsheet. My goal is to select the contract name from the drop down box and automatically be directed to the section of the worksheet where that contract is located. I could not locate and guidance online to do something like this.
Any assistance would be greatly appreciated!