Using A Macro To Select A Filter

[Jesse Peter]

Folks,

Looking for a non-VBA answer to this simple dilemma...

I have data in a table, let's say baseball teams. I want to create a macro that exports, from a website, a list of baseball teams. I want the macro to read one team in cell A1, let's say the Dodgers, and then automatically deselect 'All' and check off the 'Dodgers' in the drop-down box of the filters in the table. I could do this manually, but there are 30 teams and several tables for each team. Is there a way to instruct a macro to do so? Many thanks for any help.

JP

 

[MARK858]

Looking for a non-VBA answer to this simple dilemma...

Is there a way to instruct a macro to do so?

Just interested as to what language you are proposing your macro is going to use as you want a non-VBA answer?

 

[Jesse Peter]

Mark,

Sorry for the confusion. What I meant was I would like to use the bars, buttons, etc. given on the Excel bar to accomplish this task, as I am quite a noob when it comes to Excel and really have no experience whatsoever with VBA. But if I have to use VBA, I guess so be it. Thanks.