I have an excel sheet on which i have made different sections containing information about sales , expenses , store etc..Now each section has a Heading showing what that section is for.
But the sections are so manay that it becomes confusing finding the rite section for data entry.
Is it possible that some how i can make Button of each Heading at the start of the sheet which can enable the user to just click the button and he is at the desired section. Like if suppose the Expenses heading is in Cell AA11 the button should be such that when we click the button it takes the user on that cell.
Also there has to be a button which takes the user back to the cells where all the buttons of different sections are present.
Please guide me steps wise.
Thankyou.
But the sections are so manay that it becomes confusing finding the rite section for data entry.
Is it possible that some how i can make Button of each Heading at the start of the sheet which can enable the user to just click the button and he is at the desired section. Like if suppose the Expenses heading is in Cell AA11 the button should be such that when we click the button it takes the user on that cell.
Also there has to be a button which takes the user back to the cells where all the buttons of different sections are present.
Please guide me steps wise.
Thankyou.