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.

Designation

Software Developer

Position

Project Manager in Microsoft Office Extension Development project in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

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

Expertise

Java (J2SE, J2EE), Spring, C#, .Net, Asp.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

Projects

Thesis

Robotics Project

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

Experience

  • Software Engineering
  • Project Management
  • Team Management

Summary

  • 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

1
VBA to Hide Rows in Excel (14 Methods)

In this article, we will discuss 14 different methods to hide rows in Excel based on different criteria utilizing the VBA macro. The sample dataset that we ...

1
VBA to Merge Cells in Excel (9 Methods)

In Excel, to merge multiple cells or ranges into one singular cell using VBA, the Range.Merge method is used. Range.Merge Method in Excel Purpose: ...

0
How to Print Sheet on One Page in Excel (9 Easy Ways)

Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If you know ...

0
How to Use VBA to Insert Rows in Excel – 11 Methods

Method 1 - Applying VBA to Insert a Single Row Based on Cell Text Value in Excel Consider the following dataset. Steps: Press Alt + F11 or go to ...

0
How to Sort a Table in Excel using VBA (4 Methods)

Things to Know Before Implementing VBA to Sort Table in Excel Before implementing VBA to sort a table in Excel, there are some parameters you need to be ...

0
How to Sort a Column Using VBA in Excel (4 Methods)

Range.Sort Method in Excel VBA The Range.Sort method in Excel VBA allows you to sort a range of values. The Range object variable specifies the cells you want ...

0
How to Remove Outliers in Excel (3 Ways)

Method 1 – Utilizing Trimmean to Calculate Average without Outliers Below, we have data from Cells B5 to B14. Most numbers are between 20 and 27, but two ...

0
How to Perform Custom Filter in Excel (5 Ways)

We will use the sample dataset provided below to perform our custom filter. Method 1 - Filter Value Based on Number in Excel Steps: Select any ...

0
VBA Format Function in Excel (8 Uses with Examples)

The Format function in Excel is a built-in function categorized as a String/ Text function. It is also used as a VBA function in Excel. In this article, we ...

0
How to Format a Number with VBA in Excel (4 Methods)

In the below dataset, we have the same numbers in Columns B and C.  Method 1 – Using VBA NumberFormat Property Steps: Press Alt + F11, or go to ...

0
How to Link Two Sheets in Excel – 3 Methods

Method 1 -  Using a Formula to Link Two Worksheets in Excel There are two Excel sheets:  Destination Sheet and Source Sheet. There is data in the ...

0
VBA to Format Cell in Excel (12 Ways)

In this article, we will show you how to format a cell in numerous ways in Excel with VBA. VBA to Format Cell in Excel: 12 Suitable Examples In this ...

0
VBA COUNTIF Function in Excel: 6 Examples

Method 1 - WorksheetFunction with COUNTIF in Excel VBA Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open ...

0
How to Use VBA to Remove Duplicates in Excel (6 Examples)

Sometimes you want to remove duplicate values from your worksheet to work only with the unique values. In Excel, you can remove duplicates very easily and in ...

0
How to Format Date with VBA in Excel (4 Methods)

In the dataset, the same dates are in Columns B and C. We will format the date in Column C. Method 1 – Using VBA to Format Dates Steps: Press ...

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

 

 

ExcelDemy
Logo