Step 1:
Open the web query window using Microsoft Excel as shown.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBd7Gb1D2yz7KG3WOwa4ndEsppz3KxBWsaigMPw5g36uvSmflR8rsh5OGwxK8NiurGEb0yWzG7CVKsosf93gDtcfpWzidI-R0XtkEB3NTDrkRp_G9aIetk6mJMoEKPu1ovHeSnXA/s400/Lottery1.jpg)
Step 2:Enter the following (or cut and paste) URL
http://www.megamillions.com/winningpicks/last_25.asp into the address box
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5ikP0VfYmZGSPPiVKuOgVgXMW1jZqde1OVl6YeiTA5gdjF6Y54T7hkaP33s2FeI_9uF70QMRqH8KrCIl1bMnC5Wvb33jCucnLuwn0-HO57395QyzURwIpj3fHK8FU2p2R1RvAeA/s400/Lottery2.jpg)
Step 3:
Accept Excel's default location for pasting the data
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKBEauDSs6acQ9Y_zlX2rOUF70Hx_E0p1WRRwAp0spTGSYWCnqkHZVMxUPllsdfV96dv64z-TucMqVAFSUyQ3WB4o9iix1RtafpGjPovIj1ez_4ARbtAbgbnsguy1142d-AYmonQ/s400/Lottery3.jpg)
La voila!, the results (only part of it shown here) are in your spread sheet now.
No comments:
Post a Comment