Hi Excel-gurus,
Right to the point:
I have created a list of all my karaokesongs in an Excel worksheet.
The list is based on these columns:
A: Disc-song (in the format XXX-XX)
B: Song Title
C: Artist
D: Media (MP3+G or Video)
E: File-path (based on A - C - B)
What I want is to type a value in a cell, i.e. G1, and have the list automatically filtered.
G1 should search in column B and C simultaneously, so I can enter artist OR song title and still find what I want.
The results can either be filtered in the list as is, OR in a textbox by itself. The results should also contain column A through D.
The point is to be able to search for an artist or title and quickly find the disc and number.
Anyone have an idea how to solve this? Is it solvable?
Bookmarks