Rick,

My apologies...it does do all that stuff already. The data for that one
country I was testing was bad (should've checked that first). The data shows
1997 then skips to Oct 2000. I set it to start at Oct 2000 and it went
through fine.

My last request is kinda different and probably should go on a new post but
thought I would ask you while I had you here, since you've helped already.

-After I get the data read into the say "Sheet5" column "D", how can I make
the formulas in columns "E" & "F" autofill down to the last row of data in
column "D"?

Thanks!