Pivot Table Project for Excel






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.

Skills: Excel, Data Processing, Data Entry, Visual Basic, Microsoft Office

See more: pivot table excel cnet, aspnet excel pivot table online, excel custom pivot table, excel update pivot table odbc, excel vba update closed sheet, design excel work update excel workbook, project update excel sheet, vbs update excel pivot table, vbscript update excel pivot table, code create pivot table excel sheet, pivot table project excel, pivot table project, excel pivot table 2010 project, creating pivot table project, excel vba update google sheet, excel vba create pivot table in existing sheet, automatically refresh pivot table when data in a sheet changes in excel 2007

About the Employer:
( 8 reviews ) Cypress, United States

Project ID: #22264763

Awarded to:


Hi, I am an expert in Excel and Power bi data analysis, data visualization and dashboards. I can create a master file that combines all agents worksheets ane when you have a new agent it will be added automatically th More

$140 USD in 7 days
(86 Reviews)

41 freelancers are bidding on average $146 for this job


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$220 USD in 4 days
(366 Reviews)

Dear Employer, I understand you need a tool wherein 30 agents will share their data at some shared location and then data can be picked up from there and graphs and other analytical tools can be created from them. I More

$250 USD in 5 days
(197 Reviews)

Hi, can you provide sample agent files, and let discuss the logic of the dashboard you want to design. You said the dashboard will gather all data from agents, ok, but also you are talking about updating, mean you need More

$200 USD in 3 days
(299 Reviews)

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.

$150 USD in 2 days
(356 Reviews)

Dear client Let's talk point by point. 1. A dashboard for all 30+ agents performance. 2. One master file for the dashboard. 3. That dashboard file updates itself from all 30+ individual files. I can do it. Kindly c More

$150 USD in 3 days
(366 Reviews)

Hi, I create creative and sophisticated financial, statistical and KPI modules in a simplified and logical manner. My Module in MS Excel analysis trends, performances, operating metrics, valuation methodology, and rati More

$300 USD in 7 days
(89 Reviews)

Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work More

$140 USD in 3 days
(125 Reviews)

Hi, Greetings. Working with pivot table makes most of the task simple, specially while we are looking for analysis data, particularly visual (chart, graphs..). I went through the resources and have planned to design a More

$100 USD in 3 days
(190 Reviews)

Hi, Would you like to see a quick demo of your project on developing Managers Dashboard that will pull data from over 30 Excel workbooks completed before you award the project? You can consider it professionally done i More

$150 USD in 7 days
(56 Reviews)

Sir,      I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from y More

$133 USD in 3 days
(103 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$250 USD in 3 days
(140 Reviews)

I can definitely help you with that. I am a professional Data analyst and Data Visualization expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to develop More

$50 USD in 1 day
(55 Reviews)

Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I am very fast typing and good in redaction or transcription. I have a lot experience with Excel, Power Point, Word, SPSS More

$194 USD in 7 days
(18 Reviews)

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.

$85 USD in 5 days
(15 Reviews)

Dear Sir, I will develop a tools in Microsoft excel with buttons where you will select agent and criteria then it will show you all the info. Please share your agent files and grant access to the share folder so that More

$500 USD in 3 days
(15 Reviews)

Hi Sir, I’m a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Please, feel f More

$80 USD in 1 day
(14 Reviews)

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw More

$100 USD in 5 days
(14 Reviews)

Hello Thanks for inviting I am here to assist u inthis project I am Microsoft certified Excel Specialist, Power BI consultant and an ACCA U.K member currently working in finance dept of a leading airline of the worl More

$30 USD in 1 day
(23 Reviews)

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.

$50 USD in 4 days
(11 Reviews)

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

$150 USD in 3 days
(25 Reviews)