Terminé

Create Excel Dashboard for Open Sales Order & Inventory

Would like to create an excel dashboard that compares open orders to inventory on hand, subtracting inventory from open orders with totals.

We have 3 basic exports we can do, but need them combined with units of measurement into 1 master tab showing starting on hand and balance after open orders.

Sample sheet attached. Need to find a way for all 3 reports to be auto combined by macro or some clever excel formulas.

Compétences : Excel, Visual Basic, Traitement de Données, Saisie de Données, Visual Basic pour les apps

En voir plus : create excel order status file, peachtree create purchase order sales order, vtiger create sales order, create sales order php, excel dashboard monthly sales, sales order form excel, excel sales order, create sales order sap using function module bapi_salesorder_createfromdat2, open mt4 order excel, excel dashboard monthly sales report, create excel spreadsheet inventory sales, create excel spreadsheet inventory, excel dashboard gross sales, hi hegenabo i noticed your profile and would like to offer you my project we can discuss any details over chat it is editing sho, Open to colors but would like it to be able to go one color if needed, Hi beehive3d, I noticed your profile and would like to offer you my project. We can discuss any details over chat., Hi jackreacher262, I noticed your profile and would like to offer you my project. We can discuss any details over chat., quickbooks create packing slip from sales order, how to create purchase requisition from sales order in sap

Concernant l'employeur :
( 0 commentaires ) San Antonio, United States

Nº du projet : #32311359

Décerné à:

(489 Commentaires)
8.4

42 freelances font une offre moyenne de 131 $ pour ce travail

(851 Commentaires)
9.0
(606 Commentaires)
8.2
(337 Commentaires)
8.1
(487 Commentaires)
7.4
(228 Commentaires)
7.1
(179 Commentaires)
6.9
(85 Commentaires)
6.6
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(143 Commentaires)
6.9
(38 Commentaires)
6.3
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(117 Commentaires)
6.5
(175 Commentaires)
6.4
Logo199

Hi Rony here I am professional data entry opeartor and excel expert here who can do this task to make dashboard for you as your description thank you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(74 Commentaires)
5.8
(138 Commentaires)
6.1
ARTICLEYOUWANT

Create Excel Dashboard for Open Sales Order & Inventory Hi, I have seen your project details and completely understand the requirements. Kindly, award me this project so that we can discuss it briefly and start workin Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(34 Commentaires)
5.6
mhfsha

Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of Microsoft Excel dashbo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(109 Commentaires)
5.4
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(18 Commentaires)
4.6
GabrielBarreiro1

Hello, I have experience and skill in the creation of dashboards and in everything related to graphic interpretation of data through MS Excel. I can achieve an optimal combination between functionality and visualizatio Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(20 Commentaires)
4.6
(11 Commentaires)
4.2
Peefect

Hi, After reading description and Checking the attached excel file I found its a very easy job for me. I have done similar work many times before so please message me now so that I will start working on it. Thanks (No Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(30 Commentaires)
4.2
xcelinfinity

Hi there. My name is Benne and I'm an Excel enthusiast/trainer/solutionist. Chat up with me and I can start the project before you award.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(7 Commentaires)
4.1