User Posts: Mehedi Hasan
0
Excel VBA Sort Range with Multiple Keys
0

On day-to-day tasks, you may have to use the Excel VBA to sort range with multiple keys. You can do it quite easily with the help of Excel VBA, as I have ...

0
Excel VBA to Delete Row Based on Cell Value
0

While working in Excel, you may face thousands of rows to work with and sometimes you may need to delete rows based on cell value. You can do it quite ...

0
How to Use Excel VBA Borders Linestyle Property
0

Day-to-day tasks, you may encounter the problem of bordering cells in Excel with VBA. You can do that quite easily using Excel VBA Borders LineStyle, as I have ...

0
How to Check If Named Range Exists with Excel VBA
0

Fortunately, many of us use Excel in our business organisations. In any business organisation, we use Excel to organize data as per need. Moreover, one thing ...

0
How to Create Shipping Cost Calculator in Excel (with Easy Steps)
0

Fortunately, many of us use Excel in our business organisations. In any business organisation, we use Excel to organise data as per need. Moreover, one thing ...

0
How to Merge Multiple Cells in Excel (5 Suitable Ways)
0

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 ...

0
How to Link Checkboxes to Multiple Cells in Excel
0

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 ...

0
How to Perform Interest Rate Sensitivity Analysis in Excel
0

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 ...

0
How to Use IF Statement Based on Cell Color in Excel
0

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 ...

0
How to Use VBA Forecast Function in Excel (3 Ideal Examples)
0

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 ...

0
How to Create Gaussian Distribution Chart in Excel
0

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 ...

0
How to Check If a Number Is Odd or Even with Excel VBA
0

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need. Moreover, one thing ...

0
How to Scale X Axis in Excel Area Chart (with Easy Steps)
0

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 ...

0
Visualization Examples in Excel (12 Suitable Examples)
0

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 ...

0
How to Stop Excel from Auto Formatting Hyperlinks (3 Easy Ways)
0

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 ...

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