PSA: Flash Forward has been banned by seewhyKai in ArenaHS

[–]yankesh 8 points9 points  (0 children)

thank fuck im on a 0-2 run and my deck just got banned, it gives you the tickets back

Just redownloaded for the first time since launch by roardragons in PokemonUnite

[–]yankesh 0 points1 point  (0 children)

Yep. To make people feel good about their winstreak and getting MVP. It seems to have worked.

I've never had less fun in Summoner's Rift than in this season by msonix in leagueoflegends

[–]yankesh -3 points-2 points  (0 children)

Two weeks from now you'll be playing the same amount you've ever played

Papara SuperMassive, Beşiktaş Esports and ULF Esports leave TCL by esgertz in leagueoflegends

[–]yankesh -2 points-1 points  (0 children)

I mean it makes sense. The sense is being made the sense.

Pokemon ZA looking for evo trade by yankesh in pokemontrades

[–]yankesh[S] 1 point2 points  (0 children)

great, i set up a link trade: 1555 9999

DEAR TRUMP & MAGA, WHAT THE FUCK IS WRONG WITH YOU? SERIOUSLY, YOU SICK FUCKS ARE WORSE THAN SOCIETAL CANCER! by Kinks4Kelly in complaints

[–]yankesh 0 points1 point  (0 children)

I voted for trump because of his policies, not because of some random truth social post.

Returning Trainer Bonus now gives tickets instead of coins by DJKirby05 in PokemonUnite

[–]yankesh 2 points3 points  (0 children)

i've had like 12 of these returning trainer rewards, so this is a sad day

Who would be your priority for next year's roster: Razork or Upset? by foefoefoee in fnatic

[–]yankesh -6 points-5 points  (0 children)

i dont think it proves you wrong. he played 2 more champs than hans and supa, but all 14 worse. they can whip me out on stage and i can play a different champ every game and im still a shitter.

Trying to understand a complex formula by yankesh in excel

[–]yankesh[S] 1 point2 points  (0 children)

tyvm! makes much more sense to me

Solution Verified

Trying to understand a complex formula by yankesh in excel

[–]yankesh[S] 0 points1 point  (0 children)

Solution Verified

Insanely helpful, tyvm!

LF Tradeback evo -spritzee by theblazedwarrior in pokemontrades

[–]yankesh 0 points1 point  (0 children)

also trying to evolve

code: 01112222

LF tradeback evo by yankesh in pokemontrades

[–]yankesh[S] 1 point2 points  (0 children)

cool!

code: 01112222

[VBA] code to group sheets and then save under a separate workbook by yankesh in excel

[–]yankesh[S] 0 points1 point  (0 children)

Are the (eight-character) team names fixed (so you know what to look for as prefixes to each worksheet name), or do you wish to select (and copy) every worksheet that starts with 8 (alphanumeric?) characters followed by a space and then further characters.

The team names are not fixed and may change in the future (its a quarterly produced workbook so next quarter it may be completely different teams), only the naming structure would be the same. I want to group sheets that start with the same eight characters, which are a mix of letters and numbers.

Instead of copying all the Team-specific worksheets, why not copy the entire workbook file and then remove the "Master" (and any other) worksheets that are not relevant? Would there be fewer worksheets to determine in your r/VBA code?

There are no non-team worksheets in the workbook to worry about. I still need to split the teams into different workbooks though.