1 Attachment(s)
Need VBA beyond my knowledge
Excel 2003
Workbook with sheets "Search, A, B, C, etc (through alphabet)
Sheets a, b, c, etc have a song name in col A, and a letter code in col B.
Clicking on "search" sheet opens a userform with radio buttons.
Clicking a radio button puts a letter code value into cell D3 on the "search" sheet.
I have the above set up and will attach the file.
---------------------------------------------------------------------
VBA would search sheets (a, b, c, etc) col B for the matching code from "search" sheet cell D3.
Copy the song names with matching code to col A on "search" sheet.
When a different radio button is selected, it would clear the previous copied song names
and serach for the new matching code, and copy those songs to the "search" sheet.