Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2016, 04:41 AM
peter.hoburg peter.hoburg is offline Automating table/index creation? Clean Data. Mac OS X Automating table/index creation? Clean Data. Office for Mac 2011
Novice
Automating table/index creation? Clean Data.
 
Join Date: May 2016
Posts: 2
peter.hoburg is on a distinguished road
Default Automating table/index creation? Clean Data.

Hi all,


I am trying to take data (in the format presented bellow) and sort it into an index/table like one of the example ones bellow the data. The data is spread over multiple pages, are in multiple different bullet/number lists. Each entry can be separated by pictures, other text, etc... But the format will always be the same. Every entry will be in the exact format with nothing separating the lines. There are too many entries to do this by hand, and more entries will be added later on.

I have tried using alphabetical indexes, but (from what I can tell) each entry has to be entered by hand and that would take too much time.

Is there a way to automate this?
What is the best way to go about doing this?

Code:
DATA:
    General entry: (will always be like this with nothing separating these lines)
    The Paragraph style is consistent. Heading 4 is never used anywhere else in the Doc.
 
    Arbitrary number and part of a list(1) Name(something cool!)(Heading 4)
    Sorting Key(5.12) Useless information(8m jo mama) (Normal)
    More useless information(hard climb) (Normal)


    Real entries:
    1 Early departure: 
    5.13, 8m (Jesse Johnson, Jan 2009). 
    At left end of cliff, climb face from left (the variation climbs from right).

    2 Catch a Wave: 
    5.10+, 10m (Jared Spaulding, Jan 2009). 
    Start at bushy arete, climb face right of arete 

    3 Tic Tac: 
    5.8, 12m (Nate Furman, Jan 2009). 
    Climb the undercut start and up the face above.

    4 Quiero galleta: 
    5.6, 12m (Nate Furman, Jan 2009). 
    Climb thin face below continue left of prominent groove.

    5 Learning curve: 
    5.11+, 12m (Nate Furman, Jan 2009). 
    The only bolted line on the face (5 bolts) delicate face climb.

    6 La aleta del tiburon: 
    5.8, 12m (Markus Cavallo, Jan 2009). 
    Climb thin face over a few bulges, stay left of chimney.

Desired output: (with page numbers included to the right of each name)

Code:
Quiero galleta       5.6
Tic Tac              5.8
La aleta del tiburon 5.8
Catch a Wave         5.10+
Learning curve       5.11+
Early departure      5.13

Or: (with page numbers included to the right of each name)

Code:
5.6: 
   Quiero galleta
5.8:
    Tic Tac
    La aleta del tiburon
5.10+:
    Catch a Wave
5.11+:
    Learning curve
5.13+:
    Early departure
Thank you for all the help!
Peter
Reply With Quote
  #2  
Old 05-11-2016, 04:42 PM
macropod's Avatar
macropod macropod is offline Automating table/index creation? Clean Data. Windows 7 64bit Automating table/index creation? Clean Data. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

Cross-posted at: http://answers.microsoft.com/en-us/m...1-77ced5c48880
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-12-2016, 05:13 AM
peter.hoburg peter.hoburg is offline Automating table/index creation? Clean Data. Mac OS X Automating table/index creation? Clean Data. Office for Mac 2011
Novice
Automating table/index creation? Clean Data.
 
Join Date: May 2016
Posts: 2
peter.hoburg is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Sorry! I didn't know I should include a link with the cross post. Thank you!
Reply With Quote
Reply

Tags
automation, index, toc



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating table/index creation? Clean Data. Clean up messy data in Excel postal address list and edit duplicates to Mr. and Mrs. Cetimp Mail Merge 1 09-14-2015 04:48 AM
Automating table/index creation? Clean Data. Automark index creation Ulodesk Word 1 09-17-2014 08:22 AM
Need help in automating data from multiple sheets into a single sheet veedee Excel Programming 8 06-12-2014 10:04 PM
Automating table/index creation? Clean Data. Need help in automating data from multiple sheets into a single sheet veedee Excel 1 06-11-2014 04:01 AM
Automating table/index creation? Clean Data. VBA Code for clean all data from ms word document egyp7 Word VBA 4 05-16-2014 03:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:16 AM.


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