Completado

Help clean up a forumla intense Excel file to an easier fix

One of our old employees created an excel file with 47 tabs, all linking back to a sales report. All we really need is to input the daily sales, and daily pending values, and have the report show the Sales and Pending for the day, as well as the sales and pending on the same day (6th of december for instance for previous 5 years). Every time we change the month or the year we have to spend hours recalculating the formulas.

I need someone who can take this report and find an easier way to do it so the report autopopulates and also forwards to a new year.

Will take an Excel / Database export to do. And probably some time, can pay hourly or bid on project.

Habilidades: Excel, Procesamiento de datos, Visual Basic, Entrada de datos, Microsoft Access

Sobre el cliente:
( 23 comentarios ) Gardner, United States

Nº del proyecto: #32696107

Adjudicado a:

(1115 comentarios)
8.3

37 freelancers están ofertando un promedio de $167 por este trabajo

(346 comentarios)
8.2
(473 comentarios)
8.3
(507 comentarios)
8.4
(348 comentarios)
7.2
(325 comentarios)
7.4
(69 comentarios)
6.9
(179 comentarios)
6.4
(146 comentarios)
6.2
(177 comentarios)
6.5
(40 comentarios)
6.3
(137 comentarios)
6.1
helmot

Hi, I am a C# developer using .net6 to develop Modern web applications with Blazor. It is possible to develop mobile Apps for Android, iPhone and Windows platforms with a Blazor code in MAUI. It is also possible to de Más

$500 USD en 10 días
(16 comentarios)
5.7
frehmanpk

Respected Sir, Just move towards next level using database to manage all this data with quality. My brief intro goes here: I am an Advanced MS Access Developer, continuously writing more user-friendly applications usin Más

$750 USD en 7 días
(30 comentarios)
5.3
carina0530

Hello, ## Excel expert ## I'm fullstack expert, with over 10 years experience dealing with web, I can help create report and database by excel macro. I've previously worked on the exact similar project for American Más

$140 USD en 7 días
(3 comentarios)
4.3
Leozida

Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile). I’m ready to have a look and start right away if you give me a chance. Please share more details/file Más

$50 USD en 2 días
(22 comentarios)
3.7
davidkim24

Help clean up a forumla intense Excel file to an easier fix Hey Dear client, I have over 5 years of experience as an academic professional. As a result, i have wide pool of knowledge in Visual Basic, Data Entry, Micro Más

$100 USD en 3 días
(1 comentario)
3.1
(10 comentarios)
3.2
nenadudovicic111

Hello? I have worked on Excel macro with formula and vba code projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seek Más

$155 USD en 3 días
(4 comentarios)
2.9
ivanovatale

Hello and thank you for checking my proposal. I am an Excel and Access expert. I have been working for over 10 years in the field of workflow automation, using Excel, Access, Python, VBA, SQL for this. I worked with ma Más

$140 USD en 7 días
(1 comentario)
3.0
Jayedbinjasim

I have done my Financial Modelling and Valuation Analyst (FMVA) certification where complex excel file/calculation are done in a simple way. I have also implemented those in my pervious career life in HSBC Bank. I am s Más

$112 USD en 4 días
(2 comentarios)
1.3