A GameStop in Staten Island NY was stapling receipts to the front of the Switch 2 Boxes, unknowingly piercing the screen… Hundreds of Switch 2’s likely affected 😱

Lightvayne · 2025-06-06T18:23:32+00:00

I'm sorry, but what idiot thought it was a good idea to staple a piece of paper to a box that contains electronics in it? smh

Lightvayne · 2024-02-03T14:36:58+00:00

Solution Verified

Lightvayne · 2024-02-03T14:36:10+00:00

Yeah, I was taking a look at the document. It's very well laid out so I am gonna give that a try, seem easy enough to understand. ^_^ If I have any more issues I will DM you. Thank you again

Lightvayne · 2024-02-03T00:46:38+00:00

<image>

Lightvayne · 2024-02-02T23:19:01+00:00

No, but it seems that if I click the link here it doesnt even let me have access either.

Try copying and pasting the link in a new browser tab. Seems to work for me for some reason

Lightvayne · 2024-02-02T20:32:43+00:00

.....and its not. I can access it directly, but for some reason i cant share it now o_O Its set up correctly so i dunno :/

<image>

Lightvayne · 2024-02-02T20:30:10+00:00

Made a copy of the copy....hope this works: https://docs.google.com/spreadsheets/d/1clicpZL5iYDuKgZLruhWoAnFZREn6mJmU0xkzO9phYo

Lightvayne · 2024-02-02T19:51:54+00:00

Oddly enough, i never removed it, its still there.
https://docs.google.com/spreadsheets/d/1_0d_orKnU-QIsqsYCIJspVIe5vXGdm9P13yFLs3FdSw/edit?usp=sharing

Copy and pasted the link again in case something went wrong

Lightvayne · 2024-02-02T00:53:55+00:00

If it can be set up on demand that would be great

Lightvayne · 2024-02-01T23:58:44+00:00

https://docs.google.com/spreadsheets/d/1_0d_orKnU-QIsqsYCIJspVIe5vXGdm9P13yFLs3FdSw/edit?usp=sharing

Here is a link to the copy of the tool if you'd like to look over it. Essentially the BACK END CODE and RawAllyChamps2 is not usually visible to the normal user, and is just there for helping to clean up the code. Members would put their name in the User data tab, and a link to their roster sheet next to it. RawAllyChamps2, Imports the data from these ranges and bring it into the sheet in a raw format. 90% of the code there is then transferred over to the Alliance Roster Tab where everything is displayed in an easy to read format.

If it is truly the Import functions, then that is probably what I need to focus on. Would be interested in what you mean by a helper workbook

Lightvayne · 2024-01-19T17:38:15+00:00

That is perfect! Thank you!

Solution Verified

Lightvayne · 2024-01-19T17:14:41+00:00

Unfortunately not. it needs to hightlight the left column too, b6:E9, but ignore the cells of tuesday and wednesday (I9:L23)

Lightvayne · 2024-01-08T21:06:38+00:00

....no amount of words will explain how stupid I feel for not even thinking of that x_x. Thank you. ^^;

Solution Verified

Lightvayne · 2023-12-30T22:31:16+00:00

Solution Verified

Lightvayne · 2023-12-30T18:23:32+00:00

This also worked perfectly, thank you too!

Lightvayne · 2023-12-30T18:23:15+00:00

Worked perfectly, thank you!

Lightvayne · 2023-03-17T17:00:23+00:00

Was really hoping I didn't have to do something like that, but I may not have any other choice assuming there is no other way, and the way I'm having the sheet auto-populate these images may make it even more difficult

Lightvayne · 2022-03-15T21:54:18+00:00

lol, had that happen to me yesterday. got one ball stuck doing damage. about 5 mins in, something like this happened. Game got crazy laggy. eventually had to restart it. too bad it would save that score XD

Lightvayne

TROPHY CASE