I am in need of desperate help. I have a basic understanding of VBA, but I'm certain what I want to do is pretty easy for an experienced programmer.
I have 2 worksheets (called "Search" and "(HIDDEN) RAW DATA").
> "Search" contains a drop-down list of values in cell F7.
> "(HIDDEN) RAW DATA" contains a table of data (F6:EH106). Column E7:E106 contains staff names. Row 6 of the table (F6:EH6) has headings which relate to specific skills. The same list of skills are held in a data validation list in F7 on the "Search" worksheet.
I want the VBA code to:
1. Read whatever skill has been chosen in cell F7 in Sheet "Search".
2. Search for the chosen skill in range F6:EH6 in Sheet "(HIDDEN) Raw Data".
3. Apply a Data Filter on the column header that matches F7, and filter out any blank rows.
I hope that is clear. I look forward to your response.