Завершен

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.

Навыки: Excel, Обработка данных, Visual Basic, Ввод данных, Microsoft Access

О клиенте:
( 23 отзыв(-а, -ов) ) Gardner, United States

ID проекта: #32696107

Поручен:

(1115 отзывов(-а))
8.3

37 фрилансеров(-а) готовы выполнить эту работу в среднем за $167

(346 отзывов(-а))
8.2
(473 отзывов(-а))
8.3
(507 отзывов(-а))
8.4
(348 отзывов(-а))
7.2
(325 отзывов(-а))
7.4
(69 отзывов(-а))
6.9
(179 отзывов(-а))
6.4
(146 отзывов(-а))
6.2
(177 отзывов(-а))
6.5
(40 отзывов(-а))
6.3
(137 отзывов(-а))
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 Больше

$500 USD за 10 дней(-я)
(16 отзывов(-а))
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 Больше

$750 USD за 7 дней(-я)
(30 отзывов(-а))
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 Больше

$140 USD за 7 дней(-я)
(3 отзывов(-а))
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 Больше

$50 USD за 2 дней(-я)
(22 отзывов(-а))
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 Больше

$100 USD за 3 дней(-я)
(1 отзыв)
3.1
(10 отзывов(-а))
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 Больше

$155 USD за 3 дней(-я)
(4 отзывов(-а))
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 Больше

$140 USD за 7 дней(-я)
(1 отзыв)
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 Больше

$112 USD за 4 дней(-я)
(2 отзывов(-а))
1.3