Results 1 to 1 of 1

Copying Multiple Ranges On One Sheet To Rows On Another Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2016
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    14

    Copying Multiple Ranges On One Sheet To Rows On Another Sheet

    I've written some minor macros with my other workbooks but this one is a little beyond my experience. Hope you guys can help me.

    I have a workbook that keeps Basketball statistics. Currently, I am working between two worksheets in that workbook. The source sheet is called 'Current Game' and the destination sheet is called 'Game Logs'. I have attached my workbook for reference.

    The raw data for an individual player (minutes played, field goals made/attempted, etc.) is input on the first tab (Current Game). The data is input after each quarter.

    I would like to copy the following ranges from the Current Game tab:

    C4:V4
    C6:V6
    C8:V8
    C10:V10
    C12:V12
    C14:V14
    C16:V16
    C18:V18
    C23:F23
    C25:F25
    C27:F27
    C29:F29
    C31:F31
    C33:F33
    C35:F35
    C37:F37
    C43:O43
    C45:O45
    C47:O47
    C49:O49
    C51:O51
    C53:O53
    C55:O55
    C57:O57

    Then copy that data to the Game Logs tab. The Quarter 1 stats for Totals on the Current Game tab (C4:V4) would be copied to B6:U6 on the Game Logs tab. The next data range for Quarter 2 would be copied to the first row of Quarter 2 on the Game Logs tab (Range B88:U88) and so on for each of the ranges listed above. The problem with VBA finding the next available row is it will fill in the next blank row but you'll see that there are a number of blank rows between Game Totals, Game Shooting, Advanced Stat categories and Seasons that I don't want filled in. My goal here is to record stats for all quarters, halfs, overtime and game stats for all games. From that data I can drive max values (career highs). Anyone care to take a stab at the code for this? Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 07-18-2015, 02:06 PM
  2. Replies: 1
    Last Post: 08-21-2014, 12:12 PM
  3. [SOLVED] Help with hiding or unhiding multiple ranges of rows based on cell value on another sheet
    By Jake Bierly in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-22-2013, 12:14 PM
  4. VBA: Copying multiple rows to new sheet with no blanks
    By vultimitamin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2012, 11:30 AM
  5. [SOLVED] Copying rows from multiple documents into single sheet
    By Kovu159 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2012, 10:38 AM
  6. Do While Loop Q: Copying sheet data ranges to another sheet's ranges
    By foolios in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-30-2011, 05:05 PM
  7. Copying specific cell ranges from a worksheet multiple times to a new sheet
    By kaz8772 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2009, 03:54 PM

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