Excel template task management

[kolachenad]

Dear all, I am working for a bank. My bank heirarchy is
Circle level office
Regional level office
Branches.
I am working at regional office where I daily get different Excel files from circle office for various tasks to be attended by branches. Each excel file is a task. Every excel file contains branch code and customer details.
I am calling branches many times for many tasks. So, I would like to call branches once and inform them all tasks.
Please help me out from this drudgery work.

Regards,
Srinivas

 

[AlanSidman]

Specifically, what are you looking to receive from this body of experts. We have no idea what you need or want. Suggest you show us a mocked up spreadsheet of what you have and what you want. We may be experts in Excel but are complete failures at mind reading..

 

[kolachenad]

Specifically, what are you looking to receive from this body of experts. We have no idea what you need or want. Suggest you show us a mocked up spreadsheet of what you have and what you want. We may be experts in Excel but are complete failures at mind reading..

Sir, I am having so many number of Excel files (tasks) and the common field in all files is branch code. I want a report that how many tasks are pending with specific branch.

Thank you sir
9492542460

 

[Chihiro]

Without sample file bit hard to help. I'd recommend uploading couple of examples of desensitized files.
Also, don't forget to tell us your Excel version. As that would drastically change what tools and functions are available.

But from your description... this screams proper document management system and/or use of db backend to streamline data flow.