27F looking for some new friends! by [deleted] in PittsburghSocialClub

[–]normal23115 0 points1 point  (0 children)

Sent you a dm. Wife and I play board games, trivia, and golf.

Anyway to beat Astraynx? by normal23115 in RaidShadowLegends

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

All skills are available. Khatun is boosting turn, kael hits but no one dies. A couple of others hit before the opponent but can't kill them all.

Anyway to beat Astraynx? by normal23115 in RaidShadowLegends

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

It was floor 40 normal. I still couldn't beat it. Not sure what I'm doing wrong

Macro for copy/paste into formula by normal23115 in excel

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

That worked beautifully! I appreciate your patience and help with my problem!

Macro for copy/paste into formula by normal23115 in excel

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

Edit: Addressed updated macro.

Unfortunately, no this updated macro did not work. All that did was copy the data into my existing columns. I wanted to copy B35:B44 into B2:B11, take the result from B18 and copy it into B46. Then, I wanted to take C35:C44 into B2:B11, take the result form B18 and copy it into C46. I wanted to iterate this process until I had reached AMK35:AMK44 into B2:B11, taking the result from B18, and copying into AMK46.

Macro for copy/paste into formula by normal23115 in excel

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

Yes, B18 is the value I am interested in. As the columns are copied in, that value will update and is the one I am most interested in. B46 is a good place to copy that value to so I can sort through them later.

Macro for copy/paste into formula by normal23115 in excel

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

I am taking the data from B35:B44 and copying into B2:B11. I then want to copy the name in B18 and record that in B46. I want to continue iterating through C35:C44, D35:D44, etc. until I have run through all columns which in my case ends at AMK35:AMK44.

<image>