Video – How to Use Conditional Formatting?
This video will help you to understand how you may use conditional formatting to highlight row based on conditions. Subscribe us for more updates
Protect Excel Sheet for Manual Input but Allow Programming Inputs
Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you.
VBA Code to Protect Excel Sheet for Manual Input but Allow Programming Inputs
Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you here.
VBA Code to Add Items in ListBox Control in Userform
VBA Code To Add Items In Listbox Control Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in…
How to find duplicates in excel?
How to find duplicates in excel? Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and…
Remove Duplicates in Single Column
Remove Duplicates in Excel Highlight/Select the Column A, similar to shown in below screenshot: Go To “Data” tab on Menu Bar and click on “Remove Duplicates” as shown below: Once you click on “Remove Duplicates”,…
Find Duplicate Files In Excel Using VBA
How to Find Duplicate Files In excel using VBA? Yesterday I was working on my computer and cleaning the drives to make some more space. I was surprised to see so many files saved at…
VBA Code to Find Last Column or Row of a Sheet
VBA Code to Find Last used Column or Row in Excel Sometimes as a developer, you need to take actions in Excel sheets based on last row or column. In Excel, there are two kinds…
VBA to Read Excel Data using Connection String
VBA to Read Excel Data Using Connection String Sometimes as a programmer you need to read heavy (more then 5 MB) Excel files. There are two ways you can read data from Excel files: Open…
Excel VBA Tool to Rename Files
Free File Renamer Tool – Quickly Rename files batch using Excel VBA Here is another help code and tool for programmers to rename files. You can use this tool for renaming all files available in…
VBA Code to Change Sheet Color
What is the Usage of sheet color in Excel? When we prepare a report or a dashboard it is easy to identify or analyze reports with a change of color sheet tabs. Analysts generally give…
VBA Code to Sort Data
VBA Code to Sort Data HERE IS A ONE LINE CODE FOR DEVELOPER’S REFERENCE WHICH CAN BE USED TO SORT DATA ‘Sort data in ascending order on Column F (Created At) Sheet1.Range(“A1:G” & Sheet1.Cells.SpecialCells(xlCellTypeLastCell).Row).Sort Key1:=Sheet1.Range(“F1”),…
VBA Code to Filter Data in Excel
VBA Code to Filter Data in Excel Here is an easy reference code which filters data in the sheet. In the code, we have filtered the data in three steps. Step 1: Remove existing filter from…
VBA Tool to Merge Excel Files from a Folder
Merge Excel Files From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free…
VBA Code to Change Cell Color
VBA Code To Change Cell Color Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this, you can use…
How to get RGB Codes of a Color
How to Get RGB Codes of a Color? Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this through…
VBA Code to Convert MM.DD.YYYY to DD-MMM-YYYY In Excel
VBA Code to Convert MM.DD.YYYY To DD.MMM.YYYY in Excel In different parts of the world, there are different languages spoken and written. With this, a VBA programmer also faces language related issues while writing a…
Few Simple Excel Tips – Excel Learner Should Know
Few Excel Tips 1. CHANGE DIRECTION WHEN YOU PRESS ENTER Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very…
Impress your Clients by Hiding these Simple Features
How to Hide Ribbon &Formula bar in excel? While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and…
Lock Cells to avoid editing, Hide Formulas
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…
Protect Sheets, Share Workbook, Protect Workbook
How to protect and share your workbook? Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to…