Đã hoàn thành

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.

Kĩ năng: Excel, Visual Basic

ID dự án: #28983418

Được trao cho:

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 trong 2 ngày
(87 Đánh Giá)
5.9

32 freelancer chào giá trung bình$98 cho công việc này

(814 Nhận xét)
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 Thêm

$180 USD trong 3 ngày
(398 Nhận xét)
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 trong 2 ngày
(227 Nhận xét)
8.0
P0L

(454 Nhận xét)
7.8
(295 Nhận xét)
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 trong 1 ngày
(175 Nhận xét)
6.6
(187 Nhận xét)
6.6
(60 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(158 Nhận xét)
6.0
(103 Nhận xét)
5.9
writingapp

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

$60 USD trong 1 ngày
(84 Nhận xét)
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 Thêm

$70 USD trong 1 ngày
(45 Nhận xét)
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 Thêm

$70 USD trong 2 ngày
(29 Nhận xét)
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 Thêm

$50 USD trong 1 ngày
(47 Nhận xét)
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 trong 1 ngày
(27 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(13 Nhận xét)
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 Thêm

$80 USD trong 1 ngày
(21 Nhận xét)
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 Thêm

$40 USD trong 1 ngày
(9 Nhận xét)
3.7
(13 Nhận xét)
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 Thêm

$40 USD trong 7 ngày
(4 Nhận xét)
3.3