Need Help for "Creating a concept based excel project"

%3CLINGO-SUB%20id%3D%22lingo-sub-872155%22%20slang%3D%22en-US%22%3ENeed%20Help%20for%20%22Creating%20a%20concept%20based%20excel%20project%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872155%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20forum%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20concept%20based%20excel%20project%20for%20my%20team%20to%20implement%20a%20simplification%20in%20our%20day%20to%20day%20activity.%20My%20requirements%20are%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Automatic%20macro-based%20pivot%20table%20with%20auto%20sorting%20with%20largest%20values%20(Eg%3A%20the%20Vegetable%20amount%20of%201000%20need%20to%20be%20in%20the%20top)%3C%2FP%3E%3CP%3E2.%20Formulae%20for%20filter%20out%26nbsp%3Ba%20particular%20text%20available%20row%20in%20a%20new%20sheet%20(Eg%3A%20The%20rows%2C%20in%20which%20a%20column%20%22M%22%20contains%20the%20letter%20%22F%22%2C%26nbsp%3B%20that%20need%20to%20filter%20out)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ekindly%20help%20me%20out%20in%20this%20initiative.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20on%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-872155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873438%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20for%20%22Creating%20a%20concept%20based%20excel%20project%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873438%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414258%22%20target%3D%22_blank%22%3E%40Mufaza%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyes%2C%20both%20these%20things%20can%20be%20done%20with%20Excel.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20Create%20the%20pivot%20table%20and%20sort%20it%20as%20desired.%20The%20sort%20order%20will%20be%20applied%20automatically%20when%20the%20pivot%20table%20is%20refreshed.%20This%20does%20not%20need%20a%20macro.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.%20Use%20the%20AutoFilter%20functionality%2C%20which%20gives%20you%20filter%20tools%20in%20the%20column%20headers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Dear forum,

 

I am creating a concept based excel project for my team to implement a simplification in our day to day activity. My requirements are:

 

1. Automatic macro-based pivot table with auto sorting with largest values (Eg: the Vegetable amount of 1000 need to be in the top)

2. Formulae for filter out a particular text available row in a new sheet (Eg: The rows, in which a column "M" contains the letter "F",  that need to filter out)

 

kindly help me out in this initiative.

 

Thanks on advance! 

1 Reply

Hello @Mufaza ,

 

yes, both these things can be done with Excel. 

 

1. Create the pivot table and sort it as desired. The sort order will be applied automatically when the pivot table is refreshed. This does not need a macro.

 

2. Use the AutoFilter functionality, which gives you filter tools in the column headers.