Fergus
Well-known Member
- Joined
- Mar 10, 2004
- Messages
- 1,174
I have a large amount of data on an Excel worksheet, 4000 rows. The data is split into sections, each section with a title in column D. I am trying, without success to compile an interactive index on a separate worksheet.
The Index will comprise only a list of the section titles and I want to be able to include a vba macro that will allow me to click on any particular title in the index and for that to take me straight to the matching section title in the larger worksheet of data.
If anyone can point me in the right direction as to how to achieve this I would be most grateful.
The Index will comprise only a list of the section titles and I want to be able to include a vba macro that will allow me to click on any particular title in the index and for that to take me straight to the matching section title in the larger worksheet of data.
If anyone can point me in the right direction as to how to achieve this I would be most grateful.
