This is a large question, and I appreciate any level of response that
can be given, including whether what I seek to accomplish is possible
or practical.

I am trying to determine how completely I can automate the process of
taking material from a web site and putting it into an Excel table.
The web-based tables show names and "x" for a vote under "Aye" or
"Nay." An example may be found at
http://frwebgate.access.gpo.gov/cgi-...8_cong_reports
by searching the page for fc-14 (there are other votes below this
one). As you will see, these vote tables are a small portion of a
larger report.

I would like each vote to be pulled into an Excel sheet and displayed
as follows:

Name Aye(vote1) Nay(vote1) Aye(vote2) Nay (vote2) etc.

Name1 x x
Name2 x x
etc.

Even better would be to pull the votes from multiple reports which may
be found by going to
http://www.gpoaccess.gov/serialset/creports/index.html then checking
House and putting "financial services" in the search box and clicking
submit. Not all of the reports that come up show votes. There are,
of course, a number of committees, but start with this one.

This can be done, of course, by a web query to the report in Excel,
but non-table text must be deleted, the votes lined up with "text to
columns" (fixed width), each set of votes copied and pasted
horizontally next to the preceding and repeated names (across)
deleted.

Since search engine spiders grab huge amounts of information and
e-mail addresses and other information are culled from the web, what I
am trying to do seems possible to this non-programmer. Your advice is
appreciated.


Ken