Create a button to move up/down sheet or a drop down

[drop05]

Hello, I wanted to see if it is possible to create either a button or a drop down that can take me to a section on an excel sheet. I have 10 sections that are the same but can take different values in the section

The title "Section 1" is on C12 then the next section is c78 and so on meaning each section is 66 rows a part is there a way to create a button to go up or down that many rows to show the sections, or a better maybe a drop down where I can select what section to go to from section 1-10 that way i dont have to scroll all the way up to hit the button at the top?
Unless i freeze the frame so the button stays there but i feel a drop down would be nicer and easier so no need to click the button multiple times. Thank you!
VBA or maybe a macro is what i was thinking
Thank you in advance

 

[KPKP]

Hello. A simple solution would be to create a Range Name on each section's header. Then from anywhere just hit F5 and pick from the list of Range Names. Does pretty much the same thing as a dropdown list. Cheers.

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
Double click on the range in column C that you mentioned, and the script should take you to the next range

Just double click on the range your taken to and you will taken to that range
The selected cell will be color Yellow
Just double click on that cell to be taken to next Range

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified  2/18/2022  1:58:02 PM  EST
Cancel = True
Dim ans As String
Select Case Target.Address

    Case "$C$12", "$C$78", "$C$144", "$C$210", "$C$276", "$C$342", "$C$342", "$C$408", "$C$474", "$C$540"
        ans = Target.Address
              Range(ans).Offset(66).Select
              Selection.Interior.Color = vbYellow
        End Select
        End Sub