Hi everyone.
Could someone give me some directions on how to create a spreadsheet that fills automatically whenever I insert a character elsewhere in the spreadsheet to label a song? Here's a picture to clarify
1.jpg
This is what I have. It's a simple list that highlights the line when certain letters are typed. I have some sheets of songs and one called "Playlists". My idea (if possible) is to create a formula - or use any other tool that I'm unaware of - that automatically fills the Playlist sheet sorting the songs tagged with specific letters into specific columns. Using the example above, the playlist sheet should output two columns - A and L - and fill the lines below it with the title of the song in the highlighted line, just the title will do, no need for any other info. I'm quite sure this is doable in excel, I just don't know how.
I'm using excel 2013. Is there a not-too-difficult way to do this?
By the way sorry if this post is in the wrong section of the forum.
edit: can you see the picture now? (sorry for this)
Bookmarks