Here is what you do.

Go to Data menu - Import External Data - New Web Query
Copy and Paste your URL in the address box at top of query and press Go
Click the yellow Arrow pointing to the data table.
Then press Import on the boom right corner of the window.
Select the Destination cell where you want the data to go.


You can Record a Macro while performing these operations which will record a
macro that you can play back. You can edit the macro as required to make
changes.

"Natalie" wrote:

Hello,

I'm trying to work smarter. I want to learn how to create/use a macro to do
the following. I need to click on an IE link, cut and paste into Excel, and
return to the previous IE page, click the next link, cut and paste into Excel
slightly below the previous record, repeat for about 488 records. Any
suggestions?

The first page is:
http://cdec.water.ca.gov/cgi-progs/s...&display=staid

The second page is: (changing - that I cut and paste from)
http://cdec.water.ca.gov/cgi-progs/s...station_id=ABR

Rinse, repeat 487 times more. Any suggestions?

Thank you.

Natalie Vane
916-631-4548