Suoritettu

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.

Taidot: Excel, Tietojenkäsittely, Visual Basic, Tiedonsyöttö, Microsoft Access

Tietoa työnantajasta:
( 23 arvostelua ) Gardner, United States

Projektin tunnus: #32696107

Myönnetty käyttäjälle:

(1115 Arvostelua)
8.3

37 freelanceria on tarjonnut keskimäärin $167 tähän työhön

(346 arvostelua)
8.2
(473 arvostelua)
8.3
(507 arvostelua)
8.4
(348 arvostelua)
7.2
(325 arvostelua)
7.4
(69 arvostelua)
6.9
(179 arvostelua)
6.4
(146 arvostelua)
6.2
(177 arvostelua)
6.5
(40 arvostelua)
6.3
(137 arvostelua)
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 Lisää

$500 USD 10 päivässä
(16 arvostelua)
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 Lisää

$750 USD 7 päivässä
(30 arvostelua)
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 Lisää

$140 USD 7 päivässä
(3 arvostelua)
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 Lisää

$50 USD 2 päivässä
(22 arvostelua)
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 Lisää

$100 USD 3 päivässä
(1 arvostelu)
3.1
(10 arvostelua)
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 Lisää

$155 USD 3 päivässä
(4 arvostelua)
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 Lisää

$140 USD 7 päivässä
(1 arvostelu)
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 Lisää

$112 USD 4 päivässä
(2 arvostelua)
1.3