And the code should be dynamic so that if any other team added it should print accordingly.
Any Suggestion Guys? Attache the sample ExcelMIS Sheet.xlsx (21.0 KB)
Then you can use the Headnames (ie: Name, Amount, Teams, etc) , to identify the identify the new table’s excel counters. (Could be tedious but very much possible)
Once you get all the different tables in hand you can loop through each table contents to identify the TEAM (ie: HR, Finance, etc), and fetch the Amounts for each TEAM and keep count for each Team.