Terminé

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.

Compétences : Excel, Visual Basic

en voir plus : 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

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

Nº du projet : #28983418

Décerné à:

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.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(87 Commentaires)
5.9

32 freelances font une offre moyenne de 98 $ pour ce travail

(814 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(398 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(227 Commentaires)
8.0
P0L

(454 Commentaires)
7.8
(295 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(175 Commentaires)
6.6
(187 Commentaires)
6.6
(60 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(158 Commentaires)
6.0
(103 Commentaires)
5.9
writingapp

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(84 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(29 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(47 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(27 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.7
(13 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
3.3