View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to do it in Macro - 30 Nov?

Does anyone have any suggestions on how to do it in macro?
I would like to load the page from page 1 to 10.

Create a loop to run from 1 to 10

http://www.uwants.com/forumdisplay.php?fid=845&page=1
After it load the first page into data worksheet, then copy everything under
F column on load page into the first column under Summary worksheet.

http://www.uwants.com/forumdisplay.php?fid=845&page=2
After it load the second page into data worksheet, then copy everything
under F column on load page into the second column under Summary worksheet.

....

http://www.uwants.com/forumdisplay.php?fid=845&page=10
After it load the tenth page into data worksheet, then copy everything under
F column on load page into the tenth column under Summary worksheet.

Does anyone have any suggestions on how to do it in macro?
Thanks in advance for any suggestions
Eric