Count to a million

[DasCapschen 7,766]

429423

[lomk 20,663]

429424

Writing code in VBA is pretty tough actually. I know what I need the code to do, but I don't know what code to use.

[DasCapschen 7,766]

429425

That's... normal for all programming

[Dawnchaser 🌄 8,092]

429426

Edited October 31, 2017 by Dawnchaser

[DasCapschen 7,766]

429427

[Dawnchaser 🌄 8,092]

429428

Boo and or hiss, looks like you can now only carry one claymore at a time 

[DasCapschen 7,766]

429429

Aww did they fix your exploit?

[Telferi 6,906]

429430

[DasCapschen 7,766]

429431

[lomk 20,663]

429432

Maybe so, but that doesn't make it any less frustrating.

Sub KillWoona()

Dim Woona as ded

End Sub

Edited October 31, 2017 by rdluvrd00d44

[DasCapschen 7,766]

429433

I didn't claim it did

[Dawnchaser 🌄 8,092]

429434

Edited October 31, 2017 by Dawnchaser

[lomk 20,663]

429435

The first thing I'm trying to get it to do is copy the active worksheet and give you an input box to give it a name. It needs to be listed as the first worksheet. After that, I need it to add a month on the date in cell B1. Other cells with formulas I've already written will then calculate. Then I need to bring a column in and paste it to a different range as values. 

I'd record the macro, but it doesn't come in exactly the way I need it.  It's clunky and silly looking. 

Do programmers go through all five stages of grief in fifteen minutes? Because I've gone through all five stages in the last fifteen minutes.

Edited October 31, 2017 by rdluvrd00d44

[DasCapschen 7,766]

429435

Sounds about right
Depending on project and or language used the timeframe might be longer ...or shorter

 

[Dawnchaser 🌄 8,092]

429437

[lomk 20,663]

429437

It won't fix a huge issue, but it would make my life a little easier to have a button in my payroll worksheet to "create a new month" and have the computer do all the tedious work. But I only do it once a month so I'm not losing a shit load of time doing it myself. 

Maybe I can tinker with something like this when I get home. Idk. Just trying to learn some excel wizardry so I can add that to my resume. I'd imagine an accountant with VBA skills would be impressive to a future employer assuming MS Excel is relevant in 20 years.

[Dawnchaser 🌄 8,092]

429439

[lomk 20,663]

429440

If I could just automate some of the more tedious things, I could streamline some of the tasks here that seem to eat up a ton of time each payroll cycle. 

[ThePoniMan 164]

429441

[DasCapschen 7,766]

429442

[lomk 20,663]

429442

The day is here! https://imgur.com/gallery/ykiKD

Edited October 31, 2017 by rdluvrd00d44

[Dawnchaser 🌄 8,092]

429444

Edited October 31, 2017 by Dawnchaser

[lomk 20,663]

429445

[Dawnchaser 🌄 8,092]

429446

[lomk 20,663]

42944