Home

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

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies