Solved

automatically numbered headings ordered alfabetically in table of contents

Posted on 2002-06-15
4
234 Views
Last Modified: 2012-08-13
Hello,

I'm creating a document, that contains songs. I'd like each song to be numbered automatically. I use headings for that. Now, for the song document to be usefull, you have to have some way to find them back.
You can use the insert table of contents function, but then the songs are ordered by their order of occurance in the document. I want them to be ordered by title.
You can also try the index function, but then the automatically created numbers are left out. Either way, it's useless.
How do I create a list of all the headings in my document, containing their automatically created number, but sorted by their title?

Thanks in advance for any suggestions!

Yuri
0
Comment
Question by:yuri1976
4 Comments
 
LVL 13

Accepted Solution

by:
WJReid earned 100 total points
ID: 7080384
Hi yuri1976,

I take it you are using excel to create this database. If I understand you correctly, you have 1 field with an index number and a second with the title. If you use data|sort from the menu, you can sort them by either index number or title.

Regards,

WJReid
0
 
LVL 1

Expert Comment

by:packhorse
ID: 7080687
Hi Yuri1976

I guess you are using Word.
This works as I have tried it.
Highlight your table of contents.
Copy using Control C.
Paste where you want in the document
using special unformatted text.
Highlight the pasted text.
Use Table - Convert table to text.
Then sort the table by the song title column.

Regards

Packhorse
0
 
LVL 3

Author Comment

by:yuri1976
ID: 7080818
Thanks, both of you for your comments. They have been helpful, and both of them aren't too much work. Packhorse, your guess was correct by the way. I'm using Word. I tried your suggestion, and it worked up to the 'convert table to text'-step. But I don't seem to be able to create a table with more than 1 column from the table of contents after it's formatted to special unformatted text. Whatever I do, both the song number, the song title as well as the page number end up in 1 cell.
I've also tried copying the table of contents to excel and sorting it there and that worked perfectly. After I copied the data back in Word it was formatted perfectly, so this is satisfying for me.
As both of you have given comments that work on the same principle : sorting it as a table, I will split the points.
Thanks!

Yuri
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7080892
Per your request here, yuri1976, http://www.experts-exchange.com/questions/Q_20312184.html, I am processing this special award for you.  100 points to each experts.  The first increment awarded here, the second awaits expert comments in the link below:

Points for packhorse -> http://www.experts-exchange.com/jsp/qShow.jsp?qid=20312278

:) Moondancer - EE Moderator

P.S.  This helps you for the future on how to split points..
1) How to split points -> Ask Moderator assistance in Community Support with a zero point question and
the question link (include whom you wish to award what point values).  If the original question value
is OK as is, award one expert in the primary question directly, and post a new one in that same topic
area, for the other expert(s) you wish to award.  Here's how
  a)  Title = Points for __expertname)__
  b)  Comments = Paste the link (URL) to the primary question for which points are being given.
  c)  Expert then responds and you accept that response to grade and close it.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
randomize data from excell cell 15 48
adding "ungroup sheets" to existing vbs code 5 31
Text box keydown event does not work 38 42
Excel Macro 9 22
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question