I have had a search online but haven't been able to find something specific to what I need.
The main Wb "Dataset" stores the raw data sample (around 5k lines). Each of them belongs to teams and I only have use for 12 of them I.e. "Team 1" & "Team 2" etc. The sheet includes 7 colours, all of which I want to copy.
I want to copy this data to a new Wb only if they belong to each of the 12 teams. The save file path will be a specific folder in the drive. Ideally, I'd love to have each of the teams split out into separate sheets in the new Wb (I could rename them after), but I think I may thinking of something way to complex? Otherwise, I just want to copy team 1-12 data to this new Wb. (Excel 365)
Is there a possible code for this? I'm still learning VBA
The main Wb "Dataset" stores the raw data sample (around 5k lines). Each of them belongs to teams and I only have use for 12 of them I.e. "Team 1" & "Team 2" etc. The sheet includes 7 colours, all of which I want to copy.
I want to copy this data to a new Wb only if they belong to each of the 12 teams. The save file path will be a specific folder in the drive. Ideally, I'd love to have each of the teams split out into separate sheets in the new Wb (I could rename them after), but I think I may thinking of something way to complex? Otherwise, I just want to copy team 1-12 data to this new Wb. (Excel 365)
Is there a possible code for this? I'm still learning VBA
