Tamamlanmış

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.

Beceriler: Excel, Visual Basic, Veri İşleme, Veri Girişi, Uygulamalar için Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) San Antonio, United States

Proje NO: #32311359

Seçilen:

(489 Değerlendirme)
8.4

Bu iş için 42 freelancer ortalamada $131 teklif veriyor

(851 Değerlendirme)
9.0
(606 Değerlendirme)
8.2
(337 Değerlendirme)
8.1
(487 Değerlendirme)
7.4
(228 Değerlendirme)
7.1
(179 Değerlendirme)
6.9
(85 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(143 Değerlendirme)
6.9
(38 Değerlendirme)
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 Daha Fazla

$200 USD in 3 gün içinde
(117 Değerlendirme)
6.5
(175 Değerlendirme)
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 gün içinde
(74 Değerlendirme)
5.8
(138 Değerlendirme)
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 Daha Fazla

$150 USD in 3 gün içinde
(34 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(109 Değerlendirme)
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 Daha Fazla

$50 USD in 2 gün içinde
(18 Değerlendirme)
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 Daha Fazla

$170 USD in 5 gün içinde
(20 Değerlendirme)
4.6
(11 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(30 Değerlendirme)
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 gün içinde
(7 Değerlendirme)
4.1