+ Reply to Thread
Results 1 to 2 of 2

Looping and copy/paste specific rows

  1. #1
    Registered User
    Join Date
    09-26-2007
    Posts
    9

    Looping and copy/paste specific rows

    I have to extract some information from a spreadsheet and paste it into another spreadsheet with multiple sheets.

    For example, if I have:

    Row 1 User Monday Tuesday
    Row 7 jack 123/45 876/54
    Row12 john 526/4 456/3
    Row17 Bob 231/e 314/tw

    I have to create a new workbook from above, the new wb should have sheets based on the days of the week, and each sheet should have the heading user, id with the respective users.
    For Monday, the sheet will look something like
    Row 1 User ID
    Row 2 jack 123
    Row 3 john 526

    The complicated part is that, all user info. is in rows in increments of 5 starting at row 7.
    And from the id part, I only need the first three characters as you can see above.

    I have the basic code down that can copy the specific row into a new workbook. But I am having trouble using loops.

    If anyone can help, I would really appreciate it. Thank you

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    To loop trough the code you best use :

    Please Login or Register  to view this content.
    Erik
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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