2012-02-14, 13:04 #1
- Join Date
- Feb 2012
- Thanked 0 Times in 0 Posts
Macro for Importing a Hymnal Index into a Cross-Reference?
Hey all, I have a unique problem I'm trying to solve here, and any help would be GREATLY appreciated! Running Excel 2007 for Windows.
This spreadsheet is a cross-reference for a church hymnal collection, and allows me as a worship leader to see what books a particular song is located in, and particularly, the song number and other helpful information.
I'm wanting to import other hymnals to this spreadsheet that I've added to the collection. If I create an index for a given book, is there a macro to import it to the list without having to search and insert one song at a time?
Another side to it is, two hymnals may have the same title, but the title is sung to a different tune ("if statement" needed). Most hymnals will share at least some titles, so it will need to be able to recognize the titles already in the table and place the song number in the column, and add the new titles.
Here is the spreadsheet (4.5MB):
Just want to add, I'm not using this for any sort of commercial venture, just for indexing my private collection of hymnals (though I will use it for creating worship services and hymn-writing). Thanks SO much!
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2012-02-15, 17:42 #2
- Join Date
- Nov 2002
- New York, New York, USA
- Thanked 10 Times in 10 Posts
Welcome to the Lounge. Your workbook is very well organized and formatted. It already contains large quantities of data.
However, I am not sure what you specifically want to accomplish.
Generally I think you want to add more data to the workbook. In doing so what are the major issues? Avoiding duplicate songs? Organizing data from some other electronic source such as Word, Adobe PDF, or another Excel workbook?
By example if a Hymn book containing 2 Songs.
What does the raw data look like and what electronic form is it currently in?
What do you want the final Excel data to be?
What analysis do you want Excel to perform on the Data before it is added to the current Workbook?
Lastly, your Excel Workbook is a collection of data that Excel refers to as a “List” or alternatively a “Table”. Excel provides many special tools to do analysis and filtering of large Lists.
I think with a little more information you should get the assistance you require.