Prantick Bala

About author

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new places during travels, and enjoying movies and TV series in his downtime.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.



Rhino3D, Maxsurf, C++, MS Office, AutoCAD, WordPress and Excel & VBA


  • Intern at Khulna Shipyard, Khulna, Bangladesh.
  • Probationary Officer at United Commercial Bank PLC, Bangladesh.

Latest Posts From Prantick Bala

How to Make a Dynamic Data Validation List Using VBA in Excel

In dynamic data validation, when you add a new entry to the source list, the entry is automatically added to the data validation list. It is a very efficient ...

How to Delete Infinite Columns in Excel (4 Methods)

Actually, Excel doesn’t have infinite columns. Excel 2007 and all the newer versions have 16384 columns in total. The number is so huge for most of the uses of ...

How to Count Duplicates Based on Multiple Criteria in Excel

In Excel, you may have duplicate data in the same columns. These data may be a part of a unique set when you consider all the data along a row. To be ...

How to Copy Worksheet to Another Workbook Using VBA

If you want to copy your Excel worksheet to another workbook or to a new workbook with Microsoft Visual Basic Application, this is the right place for you. In ...

How to Paste From Clipboard to Excel Using VBA

If you cut or copy any text or image, it will be saved in the clipboard first. After that, you can paste the text or image anywhere such as in Word files and ...

Excel VBA to Copy Rows to Another Worksheet Based on Criteria

Copying data, based on criteria, from one sheet to another is one of the frequently done tasks in Excel. If you have a lot of rows and want to copy them on ...

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

This is the sample dataset. Method 1 - Bold Text in the Output of the Concatenate Formula. Press ALT+F11 to open VBA. In the VBA window, click the ...

How to Calculate the Duration of Time in Excel (7 Methods)

If you want to know how to calculate the duration of time in Excel, you will find this article helpful. In this article, I’ve discussed 7 different ways to ...

How to Calculate Average Percentage Increase in Excel

To find out your company's growth per year or to forecast the sales for next year, forecast the sales for next year you may need to calculate the average ...

How to Freeze the Top 3 Rows in Excel (3 Methods)

  Method 1 - Using the Freeze Panes Command to Freeze the Top 3 Rows Steps: Select the 4th row. Go to the View tab and click on Freeze Panes ...

How to Freeze Top Row and First Column in Excel (5 Methods)

While working with a large Excel worksheet, you may need to freeze the top row and first column. It will allow you to navigate through your entire worksheet ...

How to Rank Average in Excel (4 Common Scenarios)

Rank average is one of the methods of ranking data where the same values get an average rank. In Excel, there is an inbuilt statistical function- to rank data ...

How to Print Page Number in Excel (5 Easy Ways)

When you print an Excel sheet, you may want to print the sheet with page numbers. In this article, I’ll introduce you to 5 easy ways to print the page number ...

How to Set Print Area in Excel (5 Methods)

In the sample dataset we only want to print a portion of the content.     Method 1 - Set Print Area From Page Layout Tab Select the ...

How to Link Excel Workbooks (4 Effective Methods)

Sometimes you need to link one Excel workbook with other workbooks to import data or to use in a formula. In this article, I’ll show you 4 effective methods to ...

Browsing All Comments By: Prantick Bala
  1. You are welcome, Adam. Feeling happy to know that this article has solved your problem.

  2. Thanks dar for finding the article helpful.
    Would you please share your Excel sheet?
    Then I’ll be able to understand what you are actually want to do and try my best to give you a solution.

  3. Hello Paul,
    I hope you have found your solution already. If not, please share your Excel workbook with me. It is difficult to say the reason for the error message without seeing your worksheet or code. I will try my best to solve your problem.

Advanced Excel Exercises with Solutions PDF