Question Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

2 replies

This discussion is closed to new replies.