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
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)