How to have a 2007 Excel drop down box selection specify an Active Cell? - TechRepublic
Question
May 16, 2011 at 12:41 PM
mwisejay

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

by mwisejay . Updated 15 years, 1 month ago

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 discussion is locked

All Comments