- 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.
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.
32 freelances font une offre moyenne de 98 $ pour ce travail
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
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
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
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
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day
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
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
✅ 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
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
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
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
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
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