Latest Posts From Mehedi Hasan
Cell navigation in Excel refers to the process of moving around and selecting different cells within a spreadsheet. It's a fundamental skill for effective data ...
Mehedi Hasan
Step 1 - Select the Dataset We have a sample dataset with three variables, X, Y1, and Y2. We have used 2 sample equations in order to plot equations in ...
What Is a Clock Chart? There is no direct way to make a clock chart in Excel. However, you can make one using the bubble chart from the charts group of ...
Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...
Step 1 - Select Sample Items for Animation in Excel In this tutorial, we’ll use a football as our main sample item. When you press the “Start” button, the ...
In general, the ComboBox is a special feature of Excel. When we need to use a list of options in Excel, we use this feature. Oftentimes, we may need to insert ...
Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...
What Is a VBA TextBox? A TextBox is a box that receives data. It is a part of the UserForm. To insert a TextBox in a VBA UserForm: Steps: ...
Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...
In general, conditional formatting is now an integral part of the Microsoft Excel experience. This helps us identify particular values in a random or large ...
Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...
This is the sample dataset. Method 1 - Changing the Encoding by using the Web Options in Excel Steps: Select the File tab. Choose ...
In the following dataset containing information about some fruits, Apple is listed multiple times. Let's delete all the rows except those containing Apple. ...
Step 1 - Create a Database This is a sample database. Step 2 - Create an Invoice Template Select the following template: ...
Fortunately, there are a number of functions in Excel to perform various operations easily and swiftly. Sometimes, we need to use hexadecimal numbers and ...
See Our Reviews at
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.
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.
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.