Tags » Vba

ETL from Excel

Month ends are like haircuts. Towards the end of the process, there are a lot of little snips and clips. Enter month-end adjusting journal into ERP, run Jedox Integrator, rinse, repeat. 374 more words

Jedox ETL

See a Need, Fill a Need

I’ve been fairly absent from this blog lately. I’ve been busy working on a new release of Rubberduck and, honestly, there are only so many hours in a day. 651 more words


Delete even rows


Sub Delete_Every_Other_Row()

Y = False ‘ False deletes even rows (2, 4, 6…) True deletes odd rows (1, 3, 5…)
I = 1… 45 more words

Excel Tips And Tricks

Jest to dodatkowy projekt, jaki pozostał utworzony w celach dokształcania ludności.

Jeśli najpoprawniej funkcjonuje Ci się w samotności, z dala od donośnego biura, to e-biznes na pewno Tobie się spodoba. Po pierwsze masz nienormowany czas pracy, wobec tego jeżeli wstaniesz dwie godziny następnie aniżeli na ogół, nic się nie stanie. 183 more words


Multi-Axis line graph

I am playing with XY these days and come up with this Multi – Axis line graph, have a look here.

This is how this chart accept the data… 30 more words


Excel Tip of the Day!!! UsedRange

VBA Code to Find Last Row

One of the things to note is that VBA is dynamic enough to automatically determine the size of your data via rows or columns.  132 more words