Home

****** Need urgent help on this attached excel book with my requirement as written below **********

%3CLINGO-SUB%20id%3D%22lingo-sub-881884%22%20slang%3D%22en-US%22%3E******%20Need%20urgent%20help%20on%20this%20attached%20excel%20book%20with%20my%20requirement%20as%20written%20below%20**********%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881884%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20People%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.%20There%20are%204%20sheets%20in%20the%20attached%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%3A1%20Source%20data%20which%20is%20Manually%20entered%3C%2FP%3E%3CP%3ESheet%3A2%20filter%20data%20(auto)%20(based%20on%20the%20column%20name%20%22Flag%22)%20filter%20if%20contains%20%22N%22%3C%2FP%3E%3CP%3ESheet%3A3%20Pivot%20table%20from%20Sheet%202%20sheet%3C%2FP%3E%3CP%3ESheet%3A4%20output%20(templates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20requirement%20as%20below%3A%3C%2FP%3E%3CP%3E1.%20Required%20to%20fetch%20the%20below%20data%20from%20the%20Pivot%20table%20(Sheet%3A3)%20to%20the%20template%20available%20in%20the%20Sheet%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BI.%20Entity%20Name%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BII.Address%20as%20per%20transaction%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20III.Account%20holding%20bank%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20IV.OBI%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20V.BBI%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Data%20should%20be%20flexible%20to%20change%20in%20the%20output%20template%20when%20Pivot%20table%20values%20changes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20Largest%20sorted%20values%20in%20the%20pivot%20table%20and%20its%20data%20should%20be%20captured%20in%20the%20top%20templates%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.%20Data%20should%20be%20captured%20and%20matched%20with%20the%20pivot%20table%20and%20the%20template%20basis%20on%20the%20sorting%20(largest%20to%20smallest)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%20help%20me%20out%20in%20this%20above%20requirements.%20(Kindly%20find%20the%20attached%20excel%20book%20for%20your%20reference)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-881884%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%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
Mufaza
New Contributor

Dear People,

 

I am creating a concept based excel project for my team to implement a simplification in our day to day activity. There are 4 sheets in the attached workbook.

 

Sheet:1 Source data which is Manually entered

Sheet:2 filter data (auto) (based on the column name "Flag") filter if contains "N"

Sheet:3 Pivot table from Sheet 2 sheet

Sheet:4 output (templates)

 

My requirement as below:

1. Required to fetch the below data from the Pivot table (Sheet:3) to the template available in the Sheet:

     I. Entity Name

     II.Address as per transaction

    III.Account holding bank

    IV.OBI

    V.BBI

 

2. Data should be flexible to change in the output template when Pivot table values changes

 

3. Largest sorted values in the pivot table and its data should be captured in the top templates

 

4. Data should be captured and matched with the pivot table and the template basis on the sorting (largest to smallest)

 

Kindly help me out in this above requirements. (Kindly find the attached excel book for your reference)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 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