We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is…
When you run a query , for example, in SQL and you copy and paste the result in Excel, and the copied data contains, address and other numbers, it is very good to double check how the pasted data shows in Excel as numbers with hyphens and slashes in between them can be interpreted as…
This is a quick and simple VBA code with some comments about the structure and how it the basic syntax works for beginners. Credit to WiseOwlTutorials, you can check him out Youtube. Sub createAndLabelNewSheet() ‘create new worksheet // this is a comment. comment is denoted by an ‘apostrosphe sign ‘Basic VBA sentence structure ‘thing.action ‘always name…
This is a just a bit of addition to a previous post, by formatting the Excel output further using the Python XlsxWriter package. The additions are : Colour formatting has been added to the Total Cost column The “Total Cost” has been given a money formatting The above uses row : column numeric values instead…
A friend of mine asked me to take him through VLookUp Excel function. VLookUp is a powerful function in Excel which when well understood, will make your working with data in excel very easy . I found a very good tutorial on Youtube by ExcelIsFun which covers VLookUp and HLookUp. It covers over 25 Exercises on…
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.