Thanks for the effort Saggi. It is appreciated. Unfortunatly, it seems that I am guilty of not being specific enough.Here is what I need step by step:
1. We start on this URL : http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1 2. This page defaults to record 1 through 50. 3. Records 1 through 50 are copied and pasted into a spreadsheet called TEST001.XLS 4. The page "somehow" advances to the next (through code). That next page will be from record 51 to 100. 5. That is also copy and pasted in TEST001.XLS directly beneath the last record (in the case 50) 6. Again, code is created (a loop I guess) so that it once again goes to the next page that contains records 101 to 151. 7. Same as step 5. 8. Etc etc until the end of records has been encountered. In this particular case there are 18,849 records. - You can manually advance to the next page of records by pressing on the button controls on the ULR page near the bottom where it indicates "or by placement". Below is what the output should look like (from two pages only). Of course this would be in the TEST001 spreadhseet, but I couldn't figure out how to attach it here. Thanks & sorry for the confusion. 1 lalito 171-112-7 60.42% 6.15 +24610 View View 2 scotty122 210-147-10 58.82% 5.56 +24150 View View 3 eaglezzz 295-225-14 56.73% 4.71 +23750 View View 4 ForecastinFloyd 165-111-7 59.78% 5.28 +21450 View View 5 RandyC726 273-210-13 56.52% 4.11 +21000 View View 6 CC95531 349-280-13 55.48% 3.78 +20500 View View 7 IWillWinItAll 209-156-7 57.26% 3.85 +18700 View View 8 redbully 227-173-11 56.75% 3.64 +18350 View View 9 Cox37 255-199-11 56.17% 3.45 +18050 View View 10 atmraydoc 212-160-7 56.99% 3.63 +18000 View View 11 bbk 130-87-5 59.91% 4.26 +17150 View View 12 DoubleA69 267-212-14 55.74% 3.16 +16900 View View 13 fatboybbq 192-150-7 56.14% 2.58 +16870 View View 14 markjsni 158-113-3 58.30% 3.74 +16850 View View 15 kosta8 165-120-6 57.89% 3.55 +16760 View View 16 sonofsamtom 264-210-11 55.70% 3.08 +16500 View View 17 cokeyjoe 343-282-14 54.88% 2.98 +16400 View View 18 jzduit2 172-127-7 57.53% 3.39 +16150 View View 19 taquitojames 196-150-7 56.65% 3.06 +15500 View View 20 Chance2005 243-193-8 55.73% 2.87 +15350 View View 21 runk5k 199-153-11 56.53% 3.01 +15350 View View 22 laoplayah 128-89-3 58.99% 3.50 +15050 View View 23 chris2515 74-40-0 64.91% 5.07 +15000 View View 24 doggystylze 134-95-4 58.52% 3.32 +14750 View View 25 norsugai 135-96-3 58.44% 3.29 +14700 View View 26 peterp 224-177-10 55.86% 2.75 +14650 View View 27 ptmclc 105-69-1 60.34% 3.72 +14550 View View 28 ALLABOUTME 273-222-11 55.15% 2.63 +14400 View View 29 americanbj27 82-49-1 62.60% 4.16 +14050 View View 30 jwstahl80 348-291-15 54.46% 2.54 +13950 View View 31 grillbee 109-74-7 59.56% 3.35 +13800 View View 32 ryanwelser 186-144-5 56.36% 2.67 +13800 View View 33 JCYeager 159-120-7 56.99% 2.73 +13560 View View 34 Daweemz04 103-70-4 59.54% 3.15 +13440 View View 35 howwierd 181-141-7 56.21% 2.48 +13420 View View 36 chuckgale 159-120-8 56.99% 2.73 +13410 View View 37 gigglez13 161-122-6 56.89% 2.69 +13400 View View 38 riba57 285-230-9 55.34% 2.94 +13360 View View 39 91Bravo 119-84-3 58.62% 3.02 +13300 View View 40 MADMAN62 142-105-7 57.49% 2.77 +13250 View View 41 johnnyboy28 252-205-12 55.14% 2.42 +13250 View View 42 luonz 119-80-5 59.80% 3.82 +13250 View View 43 djm180 88-56-2 61.11% 3.56 +13200 View View 44 Smoothie123 233-188-10 55.34% 2.40 +13100 View View 45 nicawarrior 68-38-3 64.15% 4.25 +13100 View View 46 datsyuk 81-50-2 61.83% 3.67 +13000 View View 47 WEZEWOODS69 97-65-4 59.88% 3.16 +12750 View View 48 rooster010 218-175-10 55.47% 2.35 +12750 View View 49 master_predict 101-69-2 59.41% 3.01 +12550 View View 50 haqq55 225-182-12 55.28% 2.27 +12400 View View 51 star7 73-44-5 62.39% 3.59 +12300 View View 52 mikeshelton31 130-96-3 57.52% 2.56 +12200 View View 53 jc2211 241-197-8 55.02% 2.21 +12200 View View 54 KeyboardCowboy 228-184-9 55.34% 2.35 +12200 View View 55 Mike208 143-108-5 56.97% 2.44 +12100 View View 56 DutchMaster24 88-58-4 60.27% 3.08 +12100 View View 57 SportsLady 155-119-8 56.57% 2.36 +12050 View View 58 gatorsneil75 93-63-3 59.62% 2.88 +11850 View View 59 anth611 61-34-3 64.21% 3.84 +11800 View View 60 Chaas 50-24-1 67.57% 4.57 +11800 View View 61 tamert 74-46-2 61.67% 3.27 +11700 View View 62 gruntdabeerman 110-79-3 58.20% 2.54 +11550 View View 63 SoLjA 89-60-5 59.73% 2.82 +11500 View View 64 cowgirl2k1 209-167-7 55.59% 2.35 +11490 View View 65 ADR1977 156-121-6 56.32% 2.21 +11450 View View 66 vanwilder21 92-63-3 59.35% 2.71 +11350 View View 67 dech810 83-55-4 60.14% 2.84 +11250 View View 68 Wicked Jester 63-37-5 63.00% 3.38 +11150 View View 69 Barry69 184-147-8 55.59% 2.07 +11150 View View 70 twist38 142-109-2 56.57% 2.17 +11050 View View 71 itlianstllion11 147-117-5 55.68% 1.70 +11050 View View 72 chainlighening 255-215-9 54.26% 1.70 +11030 View View 73 Guzmania 58-33-3 63.74% 3.43 +10850 View View 74 MexicanBettor 168-133-10 55.81% 2.03 +10850 View View 75 saggwine1 157-123-6 56.07% 2.06 +10850 View View 76 ldd0821 113-83-3 57.65% 2.30 +10850 View View 77 puffNpass702 158-124-3 56.03% 2.05 +10800 View View 78 kevinloc 60-35-4 63.16% 3.29 +10750 View View 79 binh66 60-35-1 63.16% 3.29 +10750 View View 80 zelka 163-128-9 56.01% 2.10 +10700 View View 81 hltylife 106-77-7 57.92% 2.30 +10650 View View 82 cbhammer32 75-49-2 60.48% 2.73 +10550 View View 83 odie1956 317-269-14 54.10% 1.97 +10550 View View 84 toolman 131-100-5 56.71% 2.08 +10500 View View 85 RDizzle 104-75-2 58.10% 2.35 +10470 View View 86 phatassdave 198-161-6 55.15% 1.91 +10450 View View 87 goose4autigers 88-61-1 59.06% 2.45 +10450 View View 88 tob17 209-171-12 55.00% 1.90 +10450 View View 89 robwalton 242-201-8 54.63% 1.90 +10450 View View 90 Alan Palmer 178-143-8 55.45% 1.91 +10350 View View 91 insidee 156-123-5 55.91% 1.95 +10350 View View 92 brazman 101-73-2 58.05% 2.25 +10350 View View 93 martin684 222-183-13 54.81% 1.88 +10350 View View 94 JETER22 167-133-7 55.67% 1.93 +10350 View View 95 citiman 55-32-5 63.22% 3.04 +10340 View View 96 Hurley3062 302-255-18 54.22% 1.98 +10320 View View 97 mike999 70-45-1 60.87% 2.72 +10250 View View 98 kevdogg42 114-85-5 57.29% 2.11 +10250 View View 99 ROOKIEBETTOR 92-65-2 58.60% 2.32 +10250 View View 100 youngchung72 203-166-5 55.01% 1.86 +10200 View View On May 26, 2:17 am, saggi <realsa...@gmail.com> wrote: > Use those code : > > Sub Combine() > Dim J As Integer > > On Error Resume Next > Sheets(1).Select > Worksheets.Add ' add a sheet in first place > Sheets(1).Name = "Combined" > > ' copy headings > Sheets(2).Activate > Range("A1").EntireRow.Select > Selection.Copy Destination:=Sheets(1).Range("A1") > > ' work through sheets > For J = 2 To Sheets.Count ' from sheet 2 to last sheet > Sheets(J).Activate ' make the sheet active > Range("A1").Select > Selection.CurrentRegion.Select ' select all cells in this > sheets > > ' select all lines except title > Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select > > ' copy cells selected in the new sheet on last line > Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp) > (2) > Next > End Sub > > On May 24, 11:04 pm, qcan <comeonove...@gmail.com> wrote: > > > > > Hi Group, > > > I am not very knowledgable with VBA and would like some help solving a > > tedious problem. > > > - I would like to copy and past each page contained on this URL into 1 > > spreadsheet (copy/paste 1st 50, then go to line 51 and do the same for > > the second 50 etc etc.. > > http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=... > > > - Each page contains 50 records. > > - Currently there are approximatly 8500 records. > > > Currently the only way I know how to do this is to manually go to each > > page manually and copy and paste.Obviously, I would prefer something > > much more automated so that I can keep whatever remaining hair on my > > head. > > > Many thanks. > > > -- > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know > > they can subscribe to group > > athttp://groups.google.com/group/excel-macros/subscribe- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
