Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2025, 02:32 AM
Milqn Vuk Milqn Vuk is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2023
Posts: 13
Milqn Vuk is on a distinguished road
Default Need Help Author Index Creation from Paragraphs – Urgent (36 Hours Left!)

I have a document with hundreds of pages where authors' names are listed in a specific paragraph after each title. I need to create an index of authors, but manually doing this would take far too long. Is there a way to automate this process, such as by selecting the paragraph containing the authors and marking it for automatic extraction and indexing? For example, if the authors are listed in a paragraph like this:

Example Title
John Doe1, Jane Smith1, and Alice Johnson2



where numbers after surnames are in superscript.

Can a macro be created to tag paragraphs selected by me, extract the authors' names, and compile them into an index?

I’m not sure if this is even possible, but I’m desperate for a solution as I have less than 36 hours to complete this task. Any guidance or tools that could help automate this process would be immensely appreciated!
Reply With Quote
  #2  
Old 03-24-2025, 04:03 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I would start by applying a style to all those authors names. You can then use that either as the trigger to either gather all names into a TOC or to run a macro that applies index fields to all the entries.

A macro can do all the work very quickly but we would want to see a representative chunk of document so that the code would be structured correctly. If you post a small sample in a word document someone here could write the code you need.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 03-24-2025, 05:49 AM
Milqn Vuk Milqn Vuk is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2023
Posts: 13
Milqn Vuk is on a distinguished road
Default

Yes, I was thinking something exactly like that, I would apply a style to all author names and then convert them into an index. I’m very new to macros, though, so I’d really appreciate it if someone could help provide the code. I’d be immensely grateful!

Attached is the exact document I’m working with (headers/footers removed). I would say that the first page is a similar case and the second is a complicated case but in both cases, I would always say that the first name is the first word, and if there is a construction like Word-Word that is surname.
Let me know if you need additional details.
Attached Files
File Type: docx Example.docx (23.8 KB, 10 views)
Reply With Quote
  #4  
Old 03-24-2025, 05:02 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can use a concordance file for this. See:
https://www.msofficeforums.com/131815-post2.html
https://www.msofficeforums.com/word/...dex-query.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to adjust Project Duration for Summer and Winter Hours - based on number of hours per day Lou C Project 2 10-03-2021 09:35 AM
Index Match - Urgent Help chappers Excel 2 11-02-2016 03:17 AM
Automating table/index creation? Clean Data. peter.hoburg Word 2 05-12-2016 05:13 AM
Automark index creation Ulodesk Word 1 09-17-2014 08:22 AM
Need urgent help .. lost 6 hours of work .. assignments due in tomorrow Phatmat Word 1 10-15-2009 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft