asked on

VBA: Apply data filter to table column based on specific cell string

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.

Stephen

Skills-Matrix.xlsx

Jacques Geday

You say:
3. Apply a Data Filter on the column header that matches F7, and filter out any blank rows.

What do you mean by that ?
gowlfow

ASKER CERTIFIED SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Stephen Edger

ASKER

I've requested that this question be deleted for the following reason:

I solved the problem a different way (without requiring vba)

[ fanpages ]

if Mr Edger wishes to close the question without even acknowledging the effort involved in providing a solution, then this is the last question of Mr Edger's I shall be responding to.

For that reason, I object.

Jacques Geday

@Stephen Edger
EE is a forum to answer questions but also ethics plays important role whereby when an expert give you a solution, the minimum is acknowledgment for the effort and time put. I will not add also that you did not even bother to answer my question but take it that you are new to this site and from my side you are forgiven.

@fanpages
Presume OP is new to EE as just started on Jul 2 which probably not fully aware of policy yet.

gowflow

Stephen Edger

ASKER

Apologies all. I promise no offense was intended and I do appreciate the effort gone to by all. The truth is: having posted the question, on Thursday night I figured a way to solve my problem without needing vba. I am using a MATH and INDEX solution instead, which does exactly what I need.

I thought I should delete the question as it's no longer relevant, and I didn't want to waste anyone else's valuable time.

[ fanpages ]

Thank you for your reply.

In future, if you change the requirements of your question say, on a Thursday evening, please do not leave the question open (asking for "VBA code") until Sunday evening.

The time has already been wasted, but the solution does not have to be.

I suggest the question is not deleted, but remains for anybody else to review & apply to their own workbooks, if required, in the future.

[ fanpages ]

Thanks eenookami.

I will allow Mr Edger the opportunity to respond, but if this does not occur within the imposed time limit, I will comment again with a (further) suggestion for closure.