# Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He has interest in innovation and research in the field of Data Science and Machine Learning

## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

## Education

B.Sc. in Naval Architecture & Marine Engineering, BUET.

## Expertise

Microsoft Office, Adobe Photoshop, Adobe Illustrator, Lightroom, AutoCAD, Maxruf, Rhinoceros, Proteus, MATLAB, ArcGIS, CodeVision AVR

## Experience

• Technical Content Writing
• Design of an Inland Cargo Vessel
• A Study to Expand Gas Energy Supply in Bangladesh by Establishing New LNG Network Through Inland Waterways

## How to Delete All Rows Not Containing Certain Text in Excel?

In the following dataset containing information about some fruits, Apple is listed multiple times. Let's delete all the rows except those containing Apple. ...

## How to Create an Invoice in Excel with a Database – 5 Steps

Step 1 - Create a Database This is a sample database.   Step 2 - Create an Invoice Template Select the following template: ...

## Create Treemap Chart to Show Values in Excel (with Easy Steps)

What Is a Treemap Chart? The Treemap in Excel is a common type of chart that provides a hierarchical representation of the data. Usually, this type of chart ...

## Create Sunburst Chart with Percentage in Excel (with Easy Steps)

In this article, we will describe a step-by-step procedure to create a Sunburst Chart with percentage in Excel. What Is a Sunburst Chart? A Sunburst ...

## How to Fix If Macros Security Warning Has Been Disabled (4 Solutions)

Solution 1 - Solve Through the Context Menu   Steps: Open Windows File Explorer and move to the folder where you have saved the desired file. ...

## [Fixed!] Excel to PDF Hyperlinks Not Working (5 Easy Fixes)

In Microsoft Excel, hyperlinks generate a shortcut that take the user to a different part of the current workbook, a different workbook, or a website or file ...

## How to Use Food Cost Percentage Formula in Excel: 3 Methods

Method 1 - Calculating Total Food Cost Percentage Formula for Cost per Meal   Steps: Select cell C8. Write the following formula into the formula bar ...

## How to Create a Salary Payment Voucher Format in Excel

Step 1 - Enter Company Details Enter the name of the company, company location, and payment voucher month and year in the first rows of the file. ...

## How to Create an Age and Gender Chart in Excel – 3 Examples

This is the sample dataset. The Y-axis value is placed on the left. Example 1 - Using a Stacked Bar Chart Without Gaps in Between Steps: ...

## How to Apply Top and Bottom Border in Excel (3 Efficient Ways)

In this Excel tutorial, we will explain how to apply Top and Bottom border. In the image below, the cells on the left don't have borders, but on the right, ...

## How to Create a Material Balance Sheet in Excel – Easy Steps

Overview  The Material balance is quite common in Chemistry, especially in chemical reactions. It refers to the balance of materials or masses on both sides ...

## How to Add 1 Hour to Time in Excel (7 Examples)

Example 1 - Applying Conventional Formula   Steps: Enter the following formula in Cell D5. =C5+(1/24) Press Enter and use the ...

## How to Change International Number Format in Excel (4 Examples)

Example 1 - Converting European Number Format to US Number Format   Steps: Select the Cell C5 and enter the following formula. ...

## How to Calculate Daily Average in Excel (3 Methods)

The sample dataset contains hourly views of different blog posts of ExcelDemy from 9/20/2022 to 9/24/2022. From these hourly views for a day, we will return ...

## How to Convert CAD to USD in Excel (4 Easy Ways)

Method 1 - Using a General Arithmetic Formula to Convert CAD to USD Steps: Enter the following formula in cell E5: =C5*D5 Press ENTER ...

Browsing All Comments By: Mehedi Hasan
1. Hello ASHLEIGH,
Thank you for your question. We’re sorry to hear that you’re facing difficulties with the VBA code. In fact, the ExcelDemy team has tested the Excel file and the code with other workbooks following your comment and the code appears to be working correctly.
However, you can check the following 4 steps.
1. You can choose any of the two formats according to your need from Method-2. Additionally, read the Notes given after each code. This will help you to understand the code properly.
2. You must create a worksheet where you want to move the filtered rows.
3. Set the Input Worksheet and Destination Worksheet names properly with the Range.
4. In this code, we have selected Cable as filter criteria. So, the rows containing Cable within the given Range will be deleted and it will be moved to your Destination Workbook. So, make sure you have provided the criteria according to your dataset.
I hope this will solve your issue. If you still face problems, please feel free to comment again or send your workbook through e-mail so that I can check the issue.

2. Hello DERRELL,
Thank you for your question. I will be glad if I can help you even a little.
First of all, YES, you can sort two columns based on the second column without creating a new table.
If you want to know the process in detail, kindly read through the following article.
https://www.exceldemy.com/sort-data-in-excel-by-value/
I hope this will solve your issue. If you still face problems, please feel free to comment again or send your workbook through e-mail so that our team can check the issue.

3. Hello KOBUS,
Thank you for your question. We’re sorry to hear that you’re facing difficulties with the VBA code. In fact, the ExcelDemy team has tested the Excel file and the code with other workbooks following your comment and the code appears to be working correctly.
However, you can check the following 2 steps.
1. Follow the individual steps properly.
2. You have to insert the code by using the View Code option of a particular sheet. It will not work if you insert it in a VBA Module.
I hope this will solve your issue. If you still face problems, please feel free to comment again or send your workbook so that I can check the issue.

Advanced Excel Exercises with Solutions PDF