Forum Discussion

Excel's avatar
Excel
Iron Contributor
Apr 05, 2021

Question related to Autofilter using min and max value selection

Hello Everyone, Happy Easter to all😊😊   In a excel report how can we auto filter one columns values by giving min and max value manually whenever we click macro. for example if i need to perform...
excel
Macros and VBA
Excel's avatar
Excel
Iron Contributor
Apr 05, 2021

Excel 

Const columnToFilter As Long = 7 (only for G column)

This code only for G column.

 

Suppose i want to autofilter Column F to Column G

So what we write in VBA code??

 

Please help...???

 

 

Here is the attached file.

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Apr 05, 2021
    What would be the autofilter criteria for column F (Sales)?
    And your Min and Max criteria are for which column? Column G (Units)?
    • Excel's avatar
      Excel
      Iron Contributor
      Apr 06, 2021
      Thank you very much sir😊😊
      Now answer is coming correcty..😊
      Thank you for helping me
      • Subodh_Tiwari_sktneer's avatar
        Subodh_Tiwari_sktneer
        Silver Contributor
        Apr 06, 2021

        You're welcome Excel!

         

        Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.

         

        If you have any additional question, you can always open a New Question.

         

Resources