KD Jayakody

Call Us: 076 72 33 595

Macro to Generate Sheets Automatically!

Introduction: Microsoft Excel is a powerful tool for data analysis, reporting, and organization. However, as your Excel workbooks become more complex, you may find it beneficial to automate certain tasks to save time and reduce errors. Two common tasks are creating monthly sheets and deleting unnecessary sheets. In this article, we will explore two VBA […]

Automating Cell Interaction in Excel: VBA Included

This code empowers you to easily set values in A3 cells with a simple click on either A1 or B1 cells in Excel. By providing a straightforward solution, it streamlines the process of updating A3 cells, making it more efficient and user-friendly. Whether you’re a novice or an experienced Excel user, this code simplifies cell […]

Sending Email Using Excel VBA in Outlook – A Step-by-Step Guide

Sending emails through VBA (Visual Basic for Applications) in Microsoft Outlook can be a powerful and efficient way to automate your email communication. Whether you need to send routine reports, notifications, or any other type of email, you can streamline the process using VBA. In this article, we’ll walk you through the process of sending […]

VLookup Tutorial in Sinhala – Made Easy

Check the following TikTok Video or Click here to Watch the YouTube Video related to the exercise file. Then you can download the file as needed for free. @kdjayakody 🔍 Unlock the Power of VLookup in Sinhala! 🇱🇰 | Master Excel’s VLookup Function with this Step-by-Step Tutorial | Learn the Easiest Way to Fetch Data […]

Make a Balance Sheet format using Excel and Python

Copy the following code lines and paste them to the python idle. You will be able to get a new excel file like the following. from openpyxl import Workbook from openpyxl.styles import Font # Create a new workbook workbook = Workbook() # Select the active sheet sheet = workbook.active # Set column widths sheet.column_dimensions[‘A’].width = […]