Concluído

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.

Habilidades: Excel, Visual Basic, Processamento de dados, Processamento de Dados, Visual Basic para Apps

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) San Antonio, United States

ID do Projeto: #32311359

Concedido a:

(489 Comentários)
8.4

42 freelancers estão ofertando em média $131 nesse trabalho

(851 Comentários)
9.0
(606 Comentários)
8.2
(337 Comentários)
8.1
(487 Comentários)
7.4
(228 Comentários)
7.1
(179 Comentários)
6.9
(85 Comentários)
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 Mais

$50 USD em 1 dia
(143 Comentários)
6.9
(38 Comentários)
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 Mais

$200 USD in 3 dias
(117 Comentários)
6.5
(175 Comentários)
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

$150 USD in 3 dias
(74 Comentários)
5.8
(138 Comentários)
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 Mais

$150 USD in 3 dias
(34 Comentários)
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 Mais

$100 USD em 1 dia
(109 Comentários)
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 Mais

$50 USD in 2 dias
(18 Comentários)
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 Mais

$170 USD in 5 dias
(20 Comentários)
4.6
(11 Comentários)
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 Mais

$50 USD em 1 dia
(30 Comentários)
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.

$112 USD in 2 dias
(7 Comentários)
4.1