A reader needed a VBA routine to loop over financial data in Excel and insert duplicate rows for each financial transaction and modify the duplicated row. Even if you are not interested in this specific problem you will find the coding techniques used here to be very useful for your other projects. Check out the solution in the video above, also I can email … [Read more...] about Question Time – How To Duplicate Rows Then Adjust Duplicates
All Articles
How To Filter Data In LibreOffice Calc Using The Advanced Filter
How to become a data crunching wizard using a combination of the Advanced Filter and Regular Expressions in LibreOffice Calc. I originally wrote this article back in January 2016, but is seems that LibreOffice might have changed it's regular expression engine, because a lot of the stuff that worked back then doesn't seem to work now. Therefore I've completely rewritten this … [Read more...] about How To Filter Data In LibreOffice Calc Using The Advanced Filter
Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem
I first came across this Microsoft Excel vba error back in 2009, when the vba dialog box interrupted macro processing with the message "Code Execution Has Been Interrupted" and it quite literally did my head in.It's a weird error because it doesn't have an error number and in fact it isn't really an error but rather a bug for which a lot of misinformation existed on … [Read more...] about Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem
How To Enable The Developer Ribbon In Excel
You want to start using macros or visual basic for applications in Excel, but you can't find the developer menu! You can watch the video above or follow along with the article below. Which ever works best for you. Don't worry, Microsoft in their wisdom, have disabled the Developer Ribbon by default.So to enable the developer ribbon in Excel follow along … [Read more...] about How To Enable The Developer Ribbon In Excel
VBA Class Module Example – Better VBA With Objects
How to use Class Modules in Excel VBA, check out the video tutorial then the article for some extra depth. Get VBA Class Module Spreadsheet Here Also get updates when new blog or video tutorials are released. Submitting... VBA Class Modules - Some … [Read more...] about VBA Class Module Example – Better VBA With Objects