Reference: http://www.worldcommunitygrid.org/te...rdsPerPage=100



I'm looking for someone smarter than me. That's the easy part.

I'm using Microsoft Excel 2003 and I am trying to do a Data > Import External Data > from the referenced link. The data field starts with Member Name. I am importing the data into an empty worksheet named WCG. At most, the worksheet will have yesterday's manual download of data in it.

Here is the catch. It doesn't work automatically. I am trying to get the spreadsheet to import the daily updated data every time I open the .xls file. When I do get something to import, it puts unwanted data into the beginning columns, before the wanted data is brought in/imported. With this unwanted data being brought in, I can't check to see if the wanted data is being used correctly, because all the wanted data is columns to the right of where the other worksheets are looking for the data to be.

Until this is corrected, I can really determine of the import is occurring correctly each time I open the file. I suppose I could reprogram the other worksheet to compensate for the right shift, but that seems like cheating and I would like to know what I am doing wrong.

Any and all assistance in solving this exasperating issue is much appreciated.

Gandalf

P.S. - I can manually import the data successfully via copy and paste techniques. It's the automatic technique that I am sorely failing at.