I have only ever used simple spreadsheets and suspect the answer to my
question involves macros. Am using MS Office Basic Addition Excel 2003.

I want to automate procedures that I do regularly. One is to copy a table
off a website and then massage it by deleting columns/rows, sorting,
formatting, etc.

The second one is to access data piece by piece, i.e. not simply
highlighting a table, and put it into an Excel spreadsheet so it is in
essence looping each time to pick up new data.

Is it possible to fully automate these procedures? I just need guidelines as
to what Excel procedures I need to use. I believe I know enough to then be
able to work it through myself using Excel Help.

Any help would be appreciated. Thanks.