Excel 07 worksheet focus macro

tarshm

Distinguished
Mar 31, 2010
2
0
18,510
Hi i have a pretty good understanding of excel with the exception of macros so heres my question:

Basically im setting up a spread sheet to cost infrastructure projects and i would like the macro to operate as follows: when a council zone is selected "say council A" from a drop down menu i then want to be able to click a button or something and depending on which council ive selected bring me to the relevant worksheet

so selecting council A > hit button with assinged macro > bring to council A worksheet..and like wise for B, C and so on

cheers guys