Results 1 to 7 of 7

Excel 2007 : Excel macro to copy/paste every nth rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2008
    Location
    Bangalore
    Posts
    13

    Excel macro to copy/paste every nth rows

    Hi,

    I have a list of 40,000 football matches played. Data is in the format of

    11:45 +00:00, August 19, 2006
    Sheffield United v Liverpool - Barclays Premier League - ESPN Soccernet
    Score : 1 - 1
    Goals scored by Sheffield United : 1
    Time : 46',
    Goals scored by Liverpool : 1
    Time : pen 70',
    Yellow Cards : 1 - 2
    Yellow Cards time : 37', 64', 82',
    Red Cards : 0 - 0
    Red Cards time :
    ********************

    The cell count starts with A1 and goes on till the end of the sheet. The data is in a standard format. Data is present in the 1st 11 cells i.e A1:A11 which is then seperated by a "********************" followed by 5 blank cells and followed by the data for the next match. I have the paste the values into the next sheet with the headers
    (Date, Team, Score, Home Goals, Time of Home Goals, Away Goals, Time of Away Goals, Yellow Cards, Yellow Cards time, Red Cards, Red Cards Time)
    which is 11 row heads followed by 40000 match details.
    Any sugesstions. I am not a macro person so I might find this quite challenging.
    Last edited by jay36429; 11-07-2011 at 07:26 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1