Mehedi Hasan

About author

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.

Lives in

Dhaka, Bangladesh.

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
  • Undergraduate Projects
    • Design of an Inland Cargo Vessel
    • A Study to Expand Gas Energy Supply in Bangladesh by Establishing New LNG Network Through Inland Waterways

Latest Posts From Mehedi Hasan

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

When dealing with lots of data, we often represent the data in a chart form in business meetings or to the viewers or readers. The most commonly used chart is ...

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

When dealing with lots of data, we often represent the data in a chart form in business meetings or to the viewers or readers. The most commonly used chart is ...

0
Because of Your Security Settings Macros Have Been Disabled

In general, Excel is the most widely used tool for dealing with massive datasets. Moreover, we can perform myriad tasks with multiple dimensions in Excel. In ...

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

Sometimes, we need to add different kinds of files to our Excel worksheets for various purposes. In Excel, we can link the addresses of multiple PDF files to ...

0
How to Download Google Sheets to Excel (2 Easy Ways)

Microsoft Excel is a powerful program, and we use it on a regular basis. Nowadays, Google Sheets is getting very popular among the public and slowly catching ...

0
How to Rename a Workbook in Excel (4 Easy Methods)

While working in Excel, we often have to rename a workbook. In addition to this, properly named and organized worksheets and workbooks are important for the ...

0
3 Suitable Examples of Column Chart in Excel

Usually, column charts can be used to show how data changes over time or to show comparisons between things. In column charts, the categories are usually lined ...

0
How to Calculate Variance of Stock Returns in Excel (2 Easy Ways)

In general, variance is one of the most useful topics in statistics and is widely used to calculate stock returns in the stock market. Moreover, it gives you a ...

0
How to Calculate Joint Probability in Excel (3 Ideal Examples)

In mathematics, probability is the measure of the likelihood that an event will occur. However, the probability is quantified as a number between 0 and 1, ...

0
How to Use Food Cost Percentage Formula in Excel

In our daily lives, we often need to calculate food cost percentages in Excel. Especially when there are a lot of sales going on in the restaurants, they need ...

0
How to Create a Salary Payment Voucher Format in Excel

Microsoft Excel is a powerful program. In addition to this, it is quite easy and handy to operate. Also, productivity and utilization are increasing day by ...

0
How to Create Age and Gender Chart in Excel (3 Examples)

Age distribution graphs are very powerful tools for visualizing the ages of different genders, ethnicities, and groups of different ages. It not only gives ...

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

In Excel, the Top and Bottom Border lets you add borders to the top and bottom of cells or selected ranges. This formatting option is useful for visually ...

0
How to Calculate Duration of a Bond in Excel (2 Examples)

Microsoft Excel is a powerful program. In addition to this, it is quite easy and handy to operate. Also, productivity and utilization are increasing day by ...

0
How to Create Material Balance Sheet in Excel (with Easy Steps)

Microsoft Excel is a powerful software. In addition to this, it is quite easy and handy to operate. Also, productivity and utilization are increasing day by ...

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

 

 

ExcelDemy
Logo