Setting up an alphabetical index which can be clicked or scrolled to

**lily1030** · 12-22-2015, 01:59 AM

I've created an Excel file to store definitions alphabetically that I will be adding to regularly.
I have set up a macro to sort my columns alphabetically whenever I add new words, but I want to set up some sort of index or list of the letters of the alphabet at the top (or anywhere) so that I can quickly go to different words that start with the letter I click (similar to a dictionary). I have considered using hyperlinks, but I'm unsure how effective that would be since I would be adding new words daily and the list would move.

Can this be done in any way Excel?

Thanks in advance.

**skywriter** · 12-22-2015, 02:14 AM

You can use Range.Find and Application.GoTo
They're both in the VBA help search box and you can search also search this site or Google for additional information.
If you want me to help you beyond that you need to upload a workbook so I can see your data.

ViewPic

**lily1030** · 12-26-2015, 02:05 AM

Here it is, don't mind the first column that was just my attempt at some sort of sorting system.

**mike7952** · 12-26-2015, 08:50 PM

Put this formula in Cell G2. And in G1 Put the Letter you want to goto

Formula:

Please Login or Register  to view this content.

And this is a cleaned up Sort Macro

Please Login or Register  to view this content.

**lily1030** · 12-26-2015, 09:56 PM

Thank you for the formula! I've tried to modify it a bit so that I have the link set up for every letter ready to click, but the name always seems to display 0? It links correctly however.

Formula:

Please Login or Register  to view this content.

I'm putting the formula in A1, B1, C1 etc. and I've put the letter A in AJ2, B in AJ3 etc.
Any ideas?

**skywriter** · 12-26-2015, 10:55 PM

This code would go into the sheet module. Right click on the sheet tab and choose view code, then paste this code into the white window.
There's a working version installed in the file below. Make sure you enable macros, type a letter in B1 and it will jump to the first word that begins with that letter.

Please Login or Register  to view this content.

**mikerickson** · 12-26-2015, 10:57 PM

The Begins With option in Autofilter sounds like it would be superior to anything that we could put together.

**mike7952** · 12-26-2015, 11:30 PM

Put this into H1 and drag across.

Formula:

Please Login or Register  to view this content.

Setting up an alphabetical index which can be clicked or scrolled to

LinkBack

Thread Tools

Rate This Thread

Display

Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Re: Setting up an alphabetical index which can be clicked or scrolled to

Thread Information

Users Browsing this Thread

Similar Threads

Copy tabs names to index sheet in alphabetical order

[SOLVED] Index-Match which does not require alphabetical sort of names

[SOLVED] INDEX names in alphabetical order. Horizontally.

[SOLVED] Creating a unique alphabetical list (using INDEX and MATCH functions)

Preventing duplicate entries and sorting by alphabetical using Index feature

Scroll textbox if the adjacent is scrolled

Detect # scrolled-out rows and column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions