How to have a 2007 Excel drop down box selection specify an Active Cell?

By mwisejay ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums