Sanjida Ahmed

About author

Sanjida Ahmed, who graduated from Daffodil International University with a degree in Software Engineering, has worked with SOFTEKO since 2021. She has written over 100 articles on Excel & VBA and, since 2022, has worked as the Project Manager of the Excel Extension Development Project in the Software Development Department. Since starting this software development, she has established an outstanding workflow encompassing a full SDLC. She always tries to create a bridge between her skills and interests in Artificial Intelligence.


Software Developer


Project Manager in Microsoft Office Extension Development project in SOFTEKO.

Lives in

Dhaka, Bangladesh.


BSc in Software Engineering (SWE) in Daffodil International University.


Java (J2SE, J2EE), Spring, C#, .Net, (Core, MVC, Entity), C, HTML, CSS, PHP, UML, SQL, SQLite, VBA, VB.Net, MATLAB, Selenium, Git, Linux (Ubuntu, Mint), LaTeX, Microsoft Office.

Academic Projects



Robotics Project

  • Obstacle Avoiding Autonomous Car
  • Line Tracing and Locating an Object Robot


  • Software Engineering
  • Project Management
  • Team Management


  • Currently working as Project Manager in Microsoft Office Extension Development project in SOFTEKO.
  • Started technical content writing of Excel & VBA in October 2021 in SOFTEKO.

Research & Publication

Latest Posts From Sanjida Ahmed

VBA to AutoFilter with Multiple Criteria on Same Field in Excel: 4 Methods

Method 1 - Embed VBA to AutoFilter with Multiple Numeric Criteria on the Same Column Steps: Press Alt + F11 on your keyboard or go to the tab Developer ...

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

Sometimes due to technical issues AutoFilter gets hidden, or even though there is no filter applied, Excel shows that there is. In both cases, it can be ...

Import Data from Excel into Word Automatically Using VBA (2 Ways)

Once you've read these methods, you will learn how to import data from an Excel file into a Word file automatically after running VBA code and by simply ...

VBA to Get Unique Values from Column into Array in Excel (3 Criteria)

Sometimes we want to extract unique values from the dataset of our Excel workbook; But when the dataset is huge, it is hard to find the values. Implementing ...

Table Column Reference by Header in Excel VBA (6 Criteria)

Example dataset: 1. Table Column Reference by Header in Excel VBA Steps: Press Alt + F11 or go to the tab Developer -> Visual Basic to open ...

VBA to Loop through Rows of Table in Excel (11 Methods)

  Consider the following dataset, which we'll use to showcase looping through rows in a table. Method 1 - Embed VBA to Loop through Each ...

7 Solutions for Greyed Out Edit Links or Change Source Option in Excel

The Edit Links and Change Source buttons are very effective tools to transfer and update large datasets with important links from one Excel sheet to another ...

How to Find and Replace Values in Multiple Excel Files (3 Methods)

Method 1 - Find and Replace Values in Multiple Worksheets in an Excel File: In the following image, you can see that we have an Excel sheet named One. ...

Macro to Populate a Mail Merge Document from Excel

Suppose you have a certain email format and a pile of contact details of people. You have to send an email with the specified format, meaning the header, body, ...

How to Hide Formula in Excel Using VBA: 4 Methods

Method 1 - Embed VBA to Hide the Formula of a Range in Excel Steps to Protect a Sheet: Go to the tab Review. Click Protect Sheet from the Protect ...

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

This is the sample dataset for illustration. We will extract a certain result residing in one column based on conditions from the other two columns. ...

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

  Creating a Dropdown List from a Generic List in Excel In the dataset below, there are repeated values (Apple in B7 and B9) . Create a dropdown ...

Excel VBA Pivot Table to Filter Between Two Dates

A Pivot Table is a great tool to quickly summarize a large amount of data in Excel. Suppose you have a huge data consisting of so many dates but all you want ...

VBA to Remove Time from Date in Excel (3 Methods)

Sometimes there are data in an Excel worksheet that consists of both time and date. Occasionally, we want to get rid of only time or date from that sheet. ...

How to Create a Data Validation Drop-Down List with VBA in Excel (7 Methods)

Method 1 – Embedding VBA to Create a Data Validation Drop-Down List  Steps: Press Alt + F11 or go to the tab Developer -> Visual Basic to open Visual ...

Browsing All Comments By: Sanjida Ahmed
  1. Glad that we could help you. Don’t hesitate to ask if you have any more Excel related problems. Here, our experts will be happy to assist you.

  2. Hi Jesse,

    Thanks for your comment. Have you checked the method no. 2 (VBA Macro to Export Excel Contents with Specified Range to a Pipe Delimited Text File) of this article? I think that solves your problem.

  3. Hi James, In some cases, Excel’s IsNumeric property doesn’t always produce the correct result in VBA. Could you please try If Cells(i, 1) = 103 Then instead of If IsNumeric(Cells(i, 1)) = 103 Then in your code?

  4. Hello Maurice,
    Really glad to help you out. Don’t hesitate to ask if you need any further assistance. Thanks.

Advanced Excel Exercises with Solutions PDF