VBA autofilter field range

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi Davesexcel

in the attacked workbook the agent data tab is updated from another report.
I've stripped down the report and removed names etc

The trends tab will show the top trends out of 39 questions if they are marked red. based on the week and the manager name. all that is working find.

what I want to show is where it says (3 out of 3 calls) who are the 3. what are the agents names.

I'm not sure I'm over complicating things using the filter macro.

in the agent data tab I have a CF set on the agent name to change the text to red if red is any of the questions 1 - 39

on the trends tab I want to try and put a filter on the question number

so the top question for manager 1 is Q35. I want to filter that question in agent data. but this will change to a another question for a different manager.

I hope I've explained it as best as I could

thanks for the help



EDIT -

i've sorted it out by using the following code

Please Login or Register  to view this content.