Here is a url for a selected state,drug, etc.
http://formularyfinder.medicare.gov/...ics=true&cnt=1

You can modify by
State=TX&plan
State=" & item in list & "&plan

You would have to create a program with a looping macro to go thru a list of
states and a list of drugs within the loop. It appears that this one would
be tough.

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> Need to go to:
> http://formularyfinder.medicare.gov/...electstate.asp
>
> Have the query go through and select each state, then choose specific
> drug.
> List all plans from that state... then go through each plan and pull
> the data from each.
>
> The only way I can do this right now is by going through each state and
> each formulary listing, then manually copy and pasting each plans
> status.
>
> There must be an easier way... Any suggestions?
>