Opv
02-15-2014, 12:15 PM
I am trying to come up with a solution to tame my ever-growing address book, which is now at over 2,000 entries. I am tired of constantly scrolling up and down every time I wanted to find the row (or particular range of rows) which I am interested in viewing/editing.
I thought of an idea recently of somehow grouping rows that have entries in the "SURNAME" field that begin with the same letter so that all of the "A's, "B's," etc., could be grouped....then possibly use VBA to hide/display only one letter of the alphabet at a time. My initial thinking was to design the code using the Worksheet_BeforeDoubleClick function, i.e., start by displaying only the first row of each group, double click on, say, the row that begins with "C" and have only the "C" group displayed, close by double clicking any row within the group, etc.
What I thought was going to be a simple matter of a simple SHOW/HIDE routine has turned out not to be so simple. Needless to say I quickly exceeded my level of competence, so much so that I don't really know how to frame my question. Does the concept described above make sense?
I thought of an idea recently of somehow grouping rows that have entries in the "SURNAME" field that begin with the same letter so that all of the "A's, "B's," etc., could be grouped....then possibly use VBA to hide/display only one letter of the alphabet at a time. My initial thinking was to design the code using the Worksheet_BeforeDoubleClick function, i.e., start by displaying only the first row of each group, double click on, say, the row that begins with "C" and have only the "C" group displayed, close by double clicking any row within the group, etc.
What I thought was going to be a simple matter of a simple SHOW/HIDE routine has turned out not to be so simple. Needless to say I quickly exceeded my level of competence, so much so that I don't really know how to frame my question. Does the concept described above make sense?