The DMZ

Iszi

00:00

@kalina I see you trying to exploit my ADD. It's not gonna... oh cool!

TildalWave

0

Q: Move rows to existing/new worksheet based on cell value

what I need is fairly simple but I can't for the life of me figure out how to write this in code. I tried looking around for a macro that could do this, but so far no luck. I have a workbook with one worksheet that contains raw data and 30 or so worksheets for different customers. Each row in th...

something like that, but what you described is a lot more basic than that

Iszi

@TildalWave VBA? Ew. #NoEspeekaDeLingo

kalina

you don't know VBA?

Iszi

@kalina Feel like I oughta, but no.

kalina

it's basically basic with some basic changes to the basic

Iszi

00:04

Prolly just as well since I shouldn't be using Excel for this shit anyway.

@kalina You gonna put that on an Xzibit meme or something now?

TildalWave

@Iszi what's difficult about it?

You want something like this...

Dim R As Range
i = 0

For Each R In Range("start_range:end_range")

  If R.Value = "some_criteria" Then

     i = i + 1
     Sheets("some_sheet").Cells(R.Column, i).Value = R.Value

  End If

Next R

kalina

I wasn't going to, no

Iszi

@TildalWave Probably nothing. I just don't have any experience with the language at all.

Thomas Pornin

Snap - I ve Got The power

►

TildalWave

@Iszi it's ... basic :)

literally

kalina

00:06

@ThomasPornin no he said the opposite

@TildalWave I told him that!

I guess he must not listen to me

TildalWave

sorry, I was busy writing metacode

kalina

your face is metacode

Iszi

@TildalWave Something seems a little wrong about that, but I can't put my finger on it right now. Finished that bit for now anyway. I'll have to come back and try to make sense of it later though.

TildalWave

hehe

kalina

WordPress database error: [MySQL server has gone away]
INSERT INTO `wp_itsec_log` (`log_type`, `log_priority`, `log_function`, `log_date`, `log_date_gm...

nice, I was only searching for another drone to crash

your website is awesome

THANKS FOR NOTHING

TildalWave

00:09

@Iszi you do know how to create static named anchors / cells in Excel, right? I mean, you select a cell, go in menu where it says, say, "A1", type in a new name for it and press enter ;)

@Iszi ah yes, it'll move each matching value into a new row, sorry about that... should be simple enough to fix

just increase the counter if the source row isn't the previous source row

0

Q: Excel/VBA How to move data from one worksheet to another after last used cell?

I've got a workbook with 9 different worksheets in which 1 of the sheets if 4 of them combined into 1 sheet for further comparison which from a copy and paste point of view is easy but im looking at it from an automation point of view as the length of rows can increase and decrease depending on d...

excel vba excel-vba

the second answer

or even better, fixed code in the question with suggestions from the accepted answer

kalina

are you nerds still talking about macros

please

some of us in here are normal

can we talk about interesting things instead

I know what you can do

I want a power pack/portable charger that is compatible with both my surface pro 4s and also my phone which charges with usb c

waits for recommendations

TildalWave

meh talk about boring

kalina

heh

TildalWave

here's something interesting, I'm pretty sure this calibration target has moved a couple hundred yards during the past year or so google.com/maps/@34.84539,-117.6912068,116m/data=!3m1!1e3

kalina

that's not interesting unless you can prove it

and even then it's less interesting than the thing I said

TildalWave

00:18

working on it

Iszi

@TildalWave WTF is that?

kalina

a picture of his face

Iszi

Damnit. Every time the application I need to be working in hangs, I pop over here for a minute while it un-hangs and end up distracted for way too long.

i.e.: I need a new frakkin' computer.

Xander

@kalina For something as big as a Surface Pro 4, you need something like the GoalZero power packs.

kalina

that's because everybody who is active in the room at the moment has a magnetic personality

or something

or you really don't like doing work

Xander

00:21

@kalina My personality is more magnificent than magnetic, I'd say.

kalina

I wonder if battlestar stargatecanceller is on netflix

Ohnana

@Xander lol

kalina

@Xander I'd say two posts in the last hour doesn't count as active

Iszi

Seriously, all this crap that's tying me up for hours could probably be scripted. Only thing needed to do manually is to tag the data in the spreadsheet, and set an action due date. Rest of it: Break the spreadsheet up according to data in a specific field, post each spreadsheet to an assigned area in a shared location, send canned e-mail with link to spreadsheet and assignment details. All that crap could be done automatically.

kalina

so automate it

Iszi

00:24

On this machine, damn script would probably still take a half-hour to run though.

kalina

irrelevant if it requires no user input

Iszi

@kalina No, it's pretty relevant. 'Cause the system will probably be nigh-unusable while it's running.

kalina

gosh stop making excuses

Xander

@kalina I'm active this very second, and that's what counts.

TildalWave

@Iszi I thought I mentioned it

it's a calibration target

Iszi

00:27

@TildalWave Yeah, for what?

kalina

your face is a calibration target

TildalWave

it wasn't moved, it's just another one, here's the one I was thinking of google.com/maps/@34.8512,-117.657266,233m/data=!3m1!1e3

kalina

so basically this entire conversation was pointless

thanks @TildalWave

TildalWave

@kalina well, not "pointless", there's two points where I thought is just one

I'm sure there's more of them

oh yeah here's another, they seem to be about 2 km apart google.com/maps/@34.8408581,-117.7262139,116m/data=!3m1!1e3

and another google.com/maps/@34.8366934,-117.7428248,116m/data=!3m1!1e3

...

Iszi

@TildalWave Like @Simon's mom's hips?

kalina

00:34

@TildalWave yawn

TildalWave

but nvm that, what the heck are these marker lines google.com/maps/@34.8234063,-117.8425788,931m/data=!3m1!1e3

kalina

OH NO YOU FOUND THE SECRET FACILITY

black helicopter time

Iszi

@TildalWave What the hell is getting you onto this?

kalina

he's a nerd and this is what nerds do?

Iszi

I think we all need to bug out before the NSA comes and burninates this place.

TildalWave

00:36

@Iszi just bored :)

Iszi

Well, everyone except @kalina. We know she likes to watch the pyro.

TildalWave

they seem to have actually painted those "blueprints" with tar on the ground

Iszi

@TildalWave Well, yeah. But you're not just stumbling across this while randomly spinning the globe eh?

TildalWave

pretty much, I needed Google Maps and that link was in my cache

I entirely forgot why I needed Google Maps in the first place LOL

interestingly there's similar markings at Groom Lake (aka Area 51) google.com/maps/@37.2695727,-115.7955545,7223m/data=!3m1!1e3 and what looks like a launch ramp spiral

with some heavy rubber tracks on the main runway

kalina

you keep saying interestingly but I'm still waiting for one interesting thing

TildalWave

00:45

it's interesting that it's used and it looks like heavily so

inner runway seems closed, but not the outer one, which might suggest they're launching mostly aircraft that go supersonic low above the ground or even still on the runway

which, if true, would be more than interesting, quite fascinating actually

kalina

or it might suggest that you sitting here wildly speculating about something you'll never be able to prove is something you find "fascinating"

TildalWave

well, I see on those maps what they let me see anyway

also, what's wrong with wild speculation?

as long as I realize that, it's quite fun

kalina

I'm looking for surface pro 4 cases and wild speculation about a so called abandoned airfield that everybody knows contains a crashed alien ship is not productive?

TildalWave

yeah but I'm not trying to be productive at all, it's either this or something even less engaging :P

kalina

I hope you're not talking about your wife.

TildalWave

00:52

it beats writing VBA code tho, c'mon you gotta admit that

@kalina neah of course not

she's fast asleep

Mark Buffalo

@ThomasPornin luls

kalina

ok my retail therapy must come to an end

now I shall make toast

mmm toast

oh I need a usb c cable

Mark Buffalo

01:18

@kalina you buy things in retailland?

silverpenguin

Sup my peeps

kalina

oh my braided usb c cables in pink

@MarkBuffalo 1 pair of shoes, 3 tshirts, 1 pyjamas, a phone case for my phone, new skin kits for my surfaces, a power bank, a cable for the power bank to plug it into a surface, and 2 braided usb c cables

silverpenguin

Shopping and crack pot alien theories. Fuck this im going to bed

Mark Buffalo

@kalina sounds fun

kalina

@silverpenguin BYE

David Freitag

01:30

Man minecraft 1.9 mods are suuuuper unstable still

Back to FarCry 4

kalina

is farcry 4 good

David Freitag

It's fantastic

kalina

I was going to get it because I have no games to play but I don't really need another reason to not be working

David Freitag

I mean, there are some annoying parts

kalina

is it better than 3?

David Freitag

01:32

Trying to snipe someone? Ok I'll spawn some wild dogs behind you and bite your ass until you die

@kalina Waaaaaay better

No sexy time though

FC4 has a more ignorable storyline, which for me is perfect

Although you still can't skip cutscenes

kalina

meh

I'll wait until I have completed more of the games in my library

David Freitag

I think it's possibly the most well-done game in recent history

kalina

really?

"the most well-done game in recent history"?

how recent is recent?

David Freitag

Yeah but that's probably biased and not very well defined, and it's from a ridiculously small sample size

kalina

is it better than deus ex human revolution?

David Freitag

01:38

ign.com/articles/2014/11/14/far-cry-4-review

kalina

is it better than grand theft auto 5?

David Freitag

I know it's IGN, however it follows my experience

@kalina They aren't really the same kind of game

kalina

@DavidFreitag you said "most well-done game"

David Freitag

But in terms of "issues" GTA V is definitely worse

kalina

you didn't split it down by category

David Freitag

01:39

GTA V had all kinds of issues (and still does I think) whereas FarCry 4 I preordered and installed on launch day and there were no issues

kalina

I never had any issues in GTA V

what about Rise of the Tomb Raider?

David Freitag

Graphics are great, combat is better than FC3 no stability issues

kalina

but it's a first person shooter

FPS combat was perfected in 1999

what about Dying Light

which btw

Dying Light + subpac on high volume + in the dark is scary

David Freitag

At any rate, regardless of my various claims, you should definitely play it

TildalWave

@DavidFreitag like how it starts at 3,700 m altitude where there's lush vegetation and tall trees?

David Freitag

01:43

@TildalWave It's a game, it's not supposed to be realistic.

kalina

@DavidFreitag but Dying Light is realistic

David Freitag

FC4 is what JC3 really should have been

@kalina Just because they aren't supposed to be realistic doesn't mean they can't be

kalina

you seem to like murder and shooting

David Freitag

I mean look at goat simulator

kalina

I want something with more story

David Freitag

01:44

@kalina Plus more explosions

kalina

and not murder and shooting story

like real story

characters I can like, or shoot in the face if I don't like

David Freitag

@kalina FC4 has a story. It's just easy to not pay attention to.

kalina

or command to detonate a nuke without evacuating if I really don't like

David Freitag

Like Just Cause

@kalina Well it's not fallout

TildalWave

@DavidFreitag you'll have to specify what qualifies as most well-done then

kalina

01:46

story matters to me more than shooting

David Freitag

9 mins ago, by David Freitag

Yeah but that's probably biased and not very well defined, and it's from a ridiculously small sample size

TildalWave

I bet you played like 10x more of recent game titles than I have

David Freitag

I bet you're wrong

TildalWave

you've mentioned more than 10 new games since I last played any

David Freitag

I have? Name them.

TildalWave

01:49

JC3 :)

FC4

that's two...

kalina

FO4

that's three

your face

David Freitag

JC3, JC4, FC3, FC4, GTA V, Fallout

kalina

that's four

TildalWave

@DavidFreitag that racing sim something

David Freitag

And I haven't even played Fallout 4

TildalWave

01:50

see? I don't even know the titles

David Freitag

@TildalWave Project Cars?

kalina

you haven't even played FO4?

why not FO4?

TildalWave

@DavidFreitag yes that

kalina

FO4 is definitely GoTY

David Freitag

Or do you mean American Truck Simulator?

@kalina Money

TildalWave

01:50

@DavidFreitag did you play Fallout 2 and 3? Because I haven't

kalina

@DavidFreitag but FO4

David Freitag

@TildalWave Fallout 2? What the hell is that?

TildalWave

no idea

see?

kalina

Fallout 1 and 2 are games that exist but aren't the same Fallout we know and love now

well they are but they're not

they're from the 90s, when games weren't even in real 3D

David Freitag

Aren't 1 & 2 2D?

kalina

01:51

and while I'll bang the drum of story, I still require 3D graphics

otherwise you're demonstrating a complete lack of effort tbh

David Freitag

So no Stardew Valley for you?

Nah, Stardew Valley is more fun as a 2D game

TildalWave

Deus Ex Human Revolution might be the most "recent" game I actually played for more than maybe an hour

kalina

DXHR is awesomesauce

TildalWave

or Bioshock 2, Portal 2,... whichever is more recent

kalina

DXMD coming later in the year

David Freitag

01:53

Portal 2 is newer I think

TildalWave

oh and Borderlands 2

David Freitag

Borderlands was fun

kalina

I bought Bioshock Infinite and played it for an hour

TildalWave

and Metro 2033 and STALKERs ... don't know the dates

kalina

I bought Borderlands 2 + all DLC and never even installed it

I bought Borderlands Pre-sequel and did the same -.-

David Freitag

01:54

I remember seeing previews for bioshock infinite like four years before it came out

kalina

I no longer pre-order games

saying that I will pre-order DXMD

Mark Buffalo

I haven't pre-ordered games since... ah, let's see. Tomb Raider II.

kalina

well I would have

but they DELAYED IT

so screw them

I will pre-order Mass Effect Andromeda though

David Freitag

@kalina Borderlands 2 and pre-sequel are the only games I have played co-op with friends

tons of fun

TildalWave

I'm cheap when it comes to games, so no pre-orders for me... I wouldn't manage to play them by the time they're under $5 on Steam anyway

kalina

01:55

all of my friends have children or boyfriends or are weird

TildalWave

what's wrong with weird?

kalina

unwilling to adjust their work shifts so they're available to play games when I'm available

TildalWave

yeah that is bad weird

David Freitag

@kalina I'm not your friend (ಥ﹏ಥ)

kalina

no internet people don't get access to anything like that

David Freitag

01:58

@TildalWave Just saying though I've only played like 2-3x as many modern games as you.

kalina

it would be like broadcasting my current "at the PC" state

David Freitag

@kalina Eh?

TildalWave

@DavidFreitag I honestly doubt that

David Freitag

@TildalWave Seriously

kalina

@DavidFreitag steam switching from away to here when you unlock your pc

TildalWave

01:59

I really hate trying new games... usually, I'd just install once more some old one I liked

David Freitag

@kalina Wat

kalina

@DavidFreitag if you go afk or open a full screen application, steam will mark you as away

if you go un-afk or close a full screen application steam marks you as present

David Freitag

Do you need to be steam friends to invite someone to game?

kalina

yes

pc master race

David Freitag

:[

kalina

02:05

oh you can buy fruit pastilles on amazon

now that's... different

David Freitag

Hmm?

kalina

and the little book of string theory

Mark Buffalo

@kalina you're a fruit

kalina

something tells me that's not a little book

but it will give me something to read

David Freitag

nurd!

kalina

02:06

no, it's a sleep aid

David Freitag

Yeah I need one of those too

I was up at 5am making eggs and bacon

kalina

I have a feeling if I were to lay on my back, hold the book above my head and then let go, it would send me to sleep shortly after

Mark Buffalo

lol

hey david, I just started my diet last night

TildalWave

if it's hardcover, paperback probably wouldn't do

Mark Buffalo

/r/keto

kalina

02:08

@TildalWave I was going to get it as an ebook so I guess it would actually be a surface hitting me in the face

David Freitag

@MarkBuffalo I decided it's far too inconvenient to cut out all bread products

Bread is just too damn convenient

kalina

your face is just too damn convenient

huh

apparently I didn't press ctrl c

David Freitag

for certain things

lol

kalina

good job that was nothing embarrassing

Mark Buffalo

@DavidFreitag Yeah, well I honestly feel really good

The horrible feeling I had for the last several months is gone

the feeling of bloat/discomfort... from eating crap food

TildalWave

02:10

@kalina funny, hardcover is available from Amazon for less than the Kindle / eBook

David Freitag

apparently my vitamin d is reaally low

kalina

@TildalWave yes but then I'd have to store a book someplace in my house

which is a fire hazard

TildalWave

I'd just settle for some Brian Greene lectures then

David Freitag

Gotta get some more D in my diet

Mark Buffalo

@DavidFreitag Might want to get more D.

kalina

02:12

@DavidFreitag that was my new year's resolution

so far, 3 months, 3D

Mark Buffalo

@kalina Yeah, Vitamin D is very important.

3D? Hrm?

kalina

oh, vitamin d

@MarkBuffalo I guess it needs a space

David Freitag

@kalina 3D? All at once? That's alotta D

kalina

no not at once

that's a bit excessive

Mark Buffalo

@kalina You know this from, uh, experience?

kalina

02:15

@MarkBuffalo no...

for one, one of those is definitely an exit

user11842

what did I just walk into

David Freitag

@kalina Well you have two hands, for consuming D that is.

@TechnikEmpire We're having a conversation about proper Vitamin D ingestion

kalina

@TechnikEmpire you didn't, there was no walking

you clicked join, you're now in here

Mark Buffalo

I feel so horrible having this kind of chat with a lady

kalina

all that happened was websockets.

Mark Buffalo

02:16

It doesn't feel proper

kalina

@MarkBuffalo you should

is it not obvious that I'm avoiding just stating the obvious?

TildalWave

@kalina worldscienceu.com/science_unplugged/themes/string-theory

there you go ;)

kalina

@TildalWave eww, reactive design with squares

user11842

@kalina but if I were an AI, then wouldn't it count as "walking in" since it's as close as I could get?

David Freitag

@kalina NURD

kalina

02:18

@TechnikEmpire an AI wouldn't make that distinction ever

@DavidFreitag ffs

TildalWave

@kalina shouldn't you be used of that on your sur-face?

kalina

@TildalWave pls my surfaces run cubase

user11842

@kalina But, I just did

kalina

I don't browse the internet on them all that much with the exception of a handful of sites while in hotels

@TechnikEmpire you're not an AI

user11842

@kalina Alright

kalina

02:19

calling yourself an intelligence is a little far fetched

artificial or not

(somebody should call the burn ward)

David Freitag

@kalina Can we give it 5 minutes, I want to watch it twitch

kalina

oh take as long as you want, I don't clean up corpses

David Freitag

That's a bad habit

If you use thermite the whole process cleans up after itself

kalina

nobody would ever believe that I killed anybody

David Freitag

Yeah especially with how you get watching video game violence

kalina

02:22

purlease mister police man officer he slipped and fell over backwards on the knife big watery eyes

Mark Buffalo

@kalina wow, I hate this kind of design

David Freitag

@kalina puhlease sir, he was cleaning his gun and it discharged into his face. 78 times!

kalina

@DavidFreitag after he stabbed himself in the chest it was obvious he was in agony so I tried to put him out of his misery but kept missing the heart

David Freitag

@kalina Well the one to the genitals was just uncalled for.

kalina

I was hoping to relieve the remainder of his blood pressure

I really need to fix my sleep pattern after this weekend

@MarkBuffalo somebody is really proud of this design

but it's so eugh

TildalWave

02:36

OK here's tonight's nn fire video for you @kalina (handpicked)

Pouring Molten salt into Water - Explosion!

►

kalina

@TildalWave I like how you can see the glass warping

oh wait, I rewound and watched the other one first

TildalWave

yeah he blows one tank up before

kalina

at like 4 min

Mark Buffalo

03:05

TildalWave

03:20

@MarkBuffalo that's one side of the coin, where's the "what they really mean when they're being polite" one?

Transcript for