Excel VBA Request for Data Extractions/Consolidation
Budget: ₹400 – ₹750 INR
This is a request for a VBA code that I can use to extract data.
Scope:
Only need everything under Expense section.
No need any subtotal or grand total grouping.
Want a vba code that I can run because we have this once a year for budget.
This is unfortunately the only way to get the data as everything is entered manually into the system and we do not have any access to the backend data. (Screenshot 1)
Output needed is excel (screenshot 2)
There can be up to 100-300 tabs with somewhat similar format where we have to tweak the pattern where only expenses is what we needed so after Expense but before Total Line2. If there is any tabs that do not have expense budget will just skip those.
Scope:
Only need everything under Expense section.
No need any subtotal or grand total grouping.
Want a vba code that I can run because we have this once a year for budget.
This is unfortunately the only way to get the data as everything is entered manually into the system and we do not have any access to the backend data. (Screenshot 1)
Output needed is excel (screenshot 2)
There can be up to 100-300 tabs with somewhat similar format where we have to tweak the pattern where only expenses is what we needed so after Expense but before Total Line2. If there is any tabs that do not have expense budget will just skip those.