Lengkap

Programmer Needed for Excel VBA Project

- Previous experience with QuickBooks Reports is a plus.

- INPUTS: I have two (2) reports that I export FROM QuickBooks TO Excel: One (1) contains Inventory Qty per SKU per Location, and the other Excel report contains Backorder Qty per SKU per Location (for customer's orders).

- OUTPUT: I want a list of SKUs with Qty>0 that are on both input reports. This will tell me which items/SKUs we have in stock but my Warehouse Pickers are not picking them.

Kemahiran: Excel, Visual Basic

Lihat lagi: excel vba project 2007, excel vba project plan, excel vba project search engine, fun excel vba project, finalize excel vba project, 1st excel vba project, excel vba project schedule, excel vba project description, online excel vba project india, excel vba directory tree file list, sample excel vba project, create help file excel vba project, excel vba project online work 2009, clean excel vba project, excel vba project ideas, excel vba project import, test unlock excel vba project, needed excel vba programmer

Tentang Majikan:
( 0 ulasan ) Bridgewater, United States

ID Projek: #28983418

Dianugerahkan kepada:

akritisood94

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.

$110 USD dalam 2 hari
(87 Ulasan)
5.9

32 pekerja bebas membida secara purata $98 untuk pekerjaan ini

(814 Ulasan)
8.8
schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sa Lagi

$180 USD dalam 3 hari
(398 Ulasan)
8.2
asin1987

Dear Employer, I understand how you want to link inventory and back order quantity using macro. I am an expert and will do your job. Please message me to discuss more. Thanks, Ashish

$123 USD dalam 2 hari
(227 Ulasan)
8.0
P0L

(454 Ulasan)
7.8
(295 Ulasan)
7.3
avinav606lx

Hey there, This can be done via formulas or using VBA programming. I’m an expert in excel VBA macros. Ping me to discuss more details. Thanks A

$45 USD dalam sehari
(175 Ulasan)
6.6
(187 Ulasan)
6.6
(60 Ulasan)
6.6
rengrish

Hi Sir, I understood the requirement completely. Need to identify which items/SKUs are in stock but still present in back log . I can complete this job quickly within 30minutes. Please ping back. Thank You Regards Rish Lagi

$30 USD dalam sehari
(158 Ulasan)
6.0
(103 Ulasan)
5.9
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

$60 USD dalam sehari
(84 Ulasan)
5.8
bhupendrayadav

I am full time freelancer, providing automation consultancy to SME/MSME companies. I can develop an Excel based automation tools to automate business processes including calculation of large data and pivot tables. Belo Lagi

$70 USD dalam sehari
(45 Ulasan)
5.8
IgeS

Hi there, You need to have an Excel-bound VBA to verify if back orders has stocks by consolidating the SKU's with QTY>0 from Inventory Qty per SKU per Location and Backorder Qty per SKU per Location reports? Please Lagi

$70 USD dalam 2 hari
(29 Ulasan)
5.1
Akib2020

✅ Expert on Advanced Excel ✅ Hi there! I can generate a list of SKUs with Qty>0 that are on both input reports. I’m expert on VBA, Macro, Nested Formula & Function, Combine Multiple Sheet, Data Cleaning, Lookup, Vlook Lagi

$50 USD dalam sehari
(47 Ulasan)
5.1
MMG2019

Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can write code to get OUTPUT as described from your Excel files. Feel free to discuss. Thanks

$50 USD dalam sehari
(27 Ulasan)
4.6
JSAConsultants

Hey! I will prepare a detailed report on inventory to trace the quantity on one click. I am a qualified chartered accountant and working in a Consultancy firm from 7 years. I had done ACCA, ICAEW, ICAP.I have experienc Lagi

$30 USD dalam sehari
(13 Ulasan)
4.3
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA script. It will be quick and accurate. I will start immediately and complete it withi Lagi

$80 USD dalam sehari
(21 Ulasan)
4.5
habalghost22

Hi , I am an MBA professional have 4yrs of experience in Analytics, Tableau, Advanced Excel, vba and Python. Being an analyst, I use excel and vba day in and day out. I don't have any experience on QuickBooks but if t Lagi

$40 USD dalam sehari
(9 Ulasan)
3.7
(13 Ulasan)
3.7
neilfirth29

I'm not sure that you will need VBA for this project unless there is some other functionality that you need. it sounds like you can achieve with good old fashioned formulas (vlookup probably) This will be simpler to ma Lagi

$40 USD dalam 7 hari
(4 Ulasan)
3.3