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!
Bookmarks