I don't know if this is possible in Excel or not but will ask. I teach Guitar lessons and have several different subscriptions to 5 or 6 different guitar oriented magazines which all feature lessons and transcriptions to songs. Two of these magazines I have accrued every single issue for the better part of 20 years.

I have students who continually ask how to play a certain song or inquire about different topics about guitar theory. I have a book of notes that list the transcriptions by magazine as well as artist, as well as, every article pertaining to the different types of theory offered. If there is something I need to read up on or search for an article or song I have to dig thru all of my notes.

I would like to enter all of this information into Excel. I'm sure a program like Access would be more beneficial but would like to see if at all possible this information could be entered into a spreadsheet. When asked about learning a particular song or some type of theory, I could then do a search in Excel and it would hopefully list which magazine, as well as by month and year the information would be located.

Any information would be appreciated.

Doug