ExcelSirJi | Excel VBA And Macros

Excel Hyperlink: how to create, change and remove

BySumit Shrimal

This tutorial shows you three easy ways to add hyperlinks in Excel. You will learn how to insert, change, and remove hyperlinks in your worksheets. It also explains how to fix links that don’t work.
Hyperlinks are often used on the internet to move between websites. In Excel, you can create links like that too. You can make a link to another cell, a different sheet, or even another workbook. You can also link to open a new Excel file or start an email message. This guide will show you how to do all of this in Excel 2016, 2013, 2010, and older versions.

Productivity and Automation | Excel VBA and Macros

Write Your First Macro in Excel

Byexcelsirji

Learn how to write your first VBA macro in Excel to automate repetitive formatting tasks across multiple worksheets. This beginner-friendly guide will walk you through the process step-by-step, from recording your actions to customizing the code for your specific needs.

Productivity and Automation | Excel VBA and Macros

VBA Code to Get User Domain Name

Byexcelsirji

Table of Content VBA Code to Get User Domain Name VBA Code to Get User Domain Name – Method 1 VBA Code to Get User Domain Name – Method 2 Steps to use this VBA…

Productivity and Automation | Excel VBA and Macros

VBA Code to Get Computer Name

Byexcelsirji

In this article we will learn about VBA code to get computer name. Excel VBA, or Visual Basic for Applications, is a programming language that can be used to automate tasks within the Microsoft Excel…

Advanced Excel Techniques | Excel VBA and Macros

Duplicate Files Finder Tool

Byexcelsirji

Duplicate Files Finder Tool is an MS Excel based tool to identify duplicate files exist in your system or shared folder. The tool takes a base folder path as input and list down all duplicate files in the folder and sub-folders. It has capability to find duplicate files by comparing the names and their size.

Advanced Excel Techniques | Excel VBA and Macros

Dummy Data Generator Tool

Byexcelsirji

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Boolean etc.

Advanced Excel Techniques | Excel VBA and Macros

Excel Files and Sheets Data Consolidation

Byexcelsirji

Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Advanced Excel Techniques | Excel VBA and Macros

Outlook Bulk Email Tool

Byexcelsirji

Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.

Advanced Excel Techniques | Excel VBA and Macros

Random Rows Selector Tool – Unprotected Version

Byexcelsirji

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in Excel.

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

Productivity and Automation | Excel VBA and Macros

ColorIndex in Excel VBA

Byexcelsirji

Colorindex in Excel VBA Today let’s try to understand how ColorIndex property in Excel VBA works. It is an easy and effective way to quickly complete the development. ColorIndex property is normally used by VBA…

Productivity and Automation | Excel VBA and Macros

VBA Code to Check if Folder Exist

Byexcelsirji

VBA Code to check if folder exist Validation is one of the important parts of any programming language. As per few studies, 60% of the code is focused on validating input or output. In this…

Productivity and Automation | Advanced Excel Techniques | Excel VBA and Macros

VBA Code to Remove Duplicate Rows

Byexcelsirji

Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Simplest Way to Create Excel Add-in

Byexcelsirji

Excel Add-in helps you to extend the features of Excel application. Using Excel Add-in, you can perform custom actions in Excel such as formatting the data, doing complex calculations which are not possible through Excel formulas, Reading or Writing data in other Excel files and so many more actions.

Excel VBA and Macros | Productivity and Automation

Excel VBA Tips you Must Know – Part 1

Byexcelsirji

Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Audit Sampling Tool

Byexcelsirji

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

Productivity and Automation | Advanced Excel Techniques | Excel VBA and Macros

VBA Code to Sum Cells by Color

Byexcelsirji

VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.

Excel VBA and Macros | Productivity and Automation

VBA Code to Delete File

Byexcelsirji

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

Excel VBA and Macros | Productivity and Automation

VBA Code to Add Border to Excel Range

Byexcelsirji

Through formatting the cells, you can make your Excel data more beautiful and easier to understand. If you record a macro to add borders to Excel range, you will notice that it generates 30 plus lines of code for just a small work. Here we are sharing one line of code which does the same thing.