Hello Experts!
I have an existing macro that gathers information from multiple sheets in the same workbook to create some lists in the workbook.
I'm stuck with a portion of this macro. The issue is to take a limited set of existing data and extend it to multiple locations.
In the attached workbook on the 'ValidationLists' tab, this is how the data is supposed to be organized. Sorting by 'Division', then by Team, then by handicap.
If you go to the 'Prep' tab, clear out columns A through D, then run the macro 'MyTest'. The macro currently grabs the appropriate player information, but I don't know how to have the final column populate the correct information because I don't have that information collocated with the player information.
The other thing to take into consideration is that sometimes, a player may play on more than one team.
I very well may be going about all this the wrong way. I'm currently using the macro in a 'static' versus 'dynamic' manner. Meaning if the player list changes from week to week (which it does), the macro will then have to be updated to account for this. I know I could use something in the macro with 'COUNTA' or 'LOOKUP', but I'm uncertain how to properly implement this. The statistic sheets are updated and imported weekly.
The player and team information is all available on the different tabs (at the top), but I'm not sure how to get the macro to 'grab AND expand' the team information (team number followed by team name) that is appropriate for each player.
I have this:
"Bremerton" "B1 - Joe Tamura" "9" "9.4167"
I need this:
"Bremerton" "B1 - Joe Tamura" "B1 - Red Dogs' Dog House Junkies" "9" "9.4167"
The Team names and numbers are located at the top of each division's worksheet tab.
I welcome suggestions for better approaches that provide flexibility for a constantly changing data set.
Shad
Start Free Trial
