-WORKING WITH SHARED FOLDERS
I have 30+ agents. Each agent has his own workbook that is saved on a shared folder.
I need to create a Managers Dashboard that will gather the data from the 30+ workbooks.
The dashboard will be on one excel sheet and I will be able to select the agent, the month, the office and then all the guages (information) will update.
Let me know how you plan to put something like this together. The turnaround time needs to be quick because it ia a small project.
42 freelancers are bidding on average $145 for this job
Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Hi There, I can help you to create a Managers Dashboard, i have done project like this, please check my profile for sample dashboard i have create. Thanks. Regards.
Hi, i can address your project, if the 30+ files are in one system. Pl clarify, where and how these files are shared. It is very important to address this EXCEL. But for file locations, your request is addressable.
i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks