How to fetch data of more than one column with single click In MS Office?

You can achieve this using various methods, depending on the structure of your data and the specific requirements you have. Here's a general approach using Excel:

Filtering with AutoFilter:

• Open your Excel file containing the records.
  • Select the entire dataset.
    • Go to the "Data" tab in the Excel ribbon.
      • Click on "Filter" to enable AutoFilter for your dataset. This will add dropdown arrows next to each column header.
        • Click on the dropdown arrow of the column you want to filter.
          • Select the criteria you want to filter by or use the search box to find specific values.
            • Excel will filter the dataset to display only the records that match your criteria.
            Using Advanced Filter:

            - If you need more complex filtering criteria or want to extract filtered data to a different location, you can use Excel's Advanced Filter feature.
            
               - Select your dataset.
            
                  - Go to the "Data" tab and click on "Advanced" in the "Sort & Filter" group.
            
                     - In the Advanced Filter dialog box, choose whether you want to filter the data in place or copy it to another location.
            
                        - Specify your filter criteria in the Criteria range box.
            
                           - Click OK, and Excel will apply the advanced filter according to your criteria.
            
                           **Using Excel Functions**:
            
                              - If you need to extract specific records based on certain conditions, you can use Excel functions like **`INDEX`**, **`MATCH`**, **`VLOOKUP`**, or **`FILTER`** (if you have Microsoft 365 subscription).
            
                                 - These functions allow you to retrieve data dynamically based on specified criteria.
            

1. Using Macros:
   • If you have very specific requirements or want to automate the process further, you can create a macro in Excel using VBA (Visual Basic for Applications).
   • Macros can be programmed to perform complex filtering, sorting, and extraction tasks with just a single click.
   • However, creating macros requires some knowledge of VBA programming. Please accept answer if this help you

Hi @Chelegonzale

want to fetch different records with single click.

What different records do you want to get? Could you show us with a sample?

Generally, you may use Filter function as jihad majed‘s suggested.

If you have further issues, welcome to post back.