Hi Tony,
Thank you for your timely response to my first thread/post in this forum.
I am not using VBA. This is a much more simple application than that. I'll upload my .xls file, if I can figure out how.
Strike one for the wizard. I had to download the WinZip program, first, but you should have a copy of my amateurish attempt at creating an .xls file. It's what I get for volunteering.
You will note that the third sheet named
WCG is where the imported data is stored. There is a
lastweek's sheet which is just a text copy of last week's Stat Report. Then, there is the
thisweek's sheet where the logic retrieves the data from the other two sheets to create the new week's Stat Report.
A lot of this is accomplished manually. I am trying to learn enough to make it a little more automatic. This attempt to retrieve the website data is my first attempt to do just that.
Sincerely,
Gandalf