Hi, a little unsure exaclty how you want your workbook to work, I have a suggestion in another direction. Se attached example. Go to sheet "db". Place the cursor in Cell E44 and select a error type using the drop down list (I just added this for "Cabling" and "DistBoard"). In the column F the Code is calculated automatically. I formatted down to line 100.
You could still have use of you buttons at the top of sheet "Db", by giving the user a possibility to read the error codes more clearly than in the drop down list. At each sheet ("Cabling" etc) you could have only one button "Back to main page".
The drop down list are using data at lines 1-41 in sheet "db" ("Data / verify"). Those lines are hidden. Unfortunately the data must be on the same sheet, and therefore I think the best way is to have them at the top and hide them.
I didn't care much about formatting in the attached file. Just a little quick example to show the possibilities.
|