Excel VBA Jobs

I am looking for someone to help me create a simple Bill of Materials (BOM) and inventory management system. I need to track electronic components in the spreadsheet but I do not need to track item locations. The spreadsheet should be able to notify me when the stock level reaches a certain quantity so that I can re-order stock as needed. Additionally, I do not require any forecasting functionality. I want to be able to create assemblies in a BOM from inventory items, display assembly manufacturing costs and save each assembly. Modification/update of assembly function will be required as components are sometimes discontinued and new components have to be used. I want to be able to store all necessary component information in the inventory database, such as Item code, item name, descript...

Hi, I need to be professional Excel/Google-sheets Expert needed. More details will be provided to interested bidder. Thanks

I am looking for a freelancer to help me create a reusable and fillable Excel scoring form for the purpose of evaluating employees. The form should incorporate calculations and formulas for accurate scoring. Skills and Experience Required: - Proficiency in Excel and VBA programming - Experience in creating fillable forms and incorporating calculations and formulas - Understanding of data validation and error checking - Ability to suggest user-friendly layout designs The freelancer should be able to work closely with me to understand the specific requirements and provide suggestions for the layout of the scoring form.

I have a furniture business and I need a kind of simple software to control the dispatch process... All the parts of a project has a bar code on it but during the packaging stage we need to "scan" all of these codes to make sure we are packing all components of the project. A part of that, we also need to convert pieces into volume so this program should do the following tasks: 1 - Import the .xml file with all the parts list and dimensions of each part; 2 - Create a "new project" with the imported data; 3 - During the packing process, the system should read each of the barcodes (BLE reader) of the parts and mark as "packed" to make sure no parts were left behind; 4 - While reading the parts the system will create a volume list, this means that for example I ...

I am looking for a freelancer who can upgrade and enhance the existing Interactive Broker API for Excel Sheet with Order Conditioning to submit bracket order trades. The upgrade should include additional order conditioning functions for bracket orders as (PriceCondition,ExecutionCondition and TimeCondition). I am aiming to achieve this upgrade and improvement within a month or so at most. Word document attached contains full details of what is required with target solution. This requires a few additional macro's to be written to the existing file only...no major code re-work required.

I am looking for a automation expert to automate a specific task for me. Task: - The automation will visit to storefront in Amazon and it will click to a extension. (The extension show products' situation) we have just two filter. The automation will check them and export suitable ones to excel or txt file. Whatever is simple for you. it is not problem. It may be complicated but it is not. i can send screenshots. Simply; The task involves checking the storefront and exporting suitable items based on a filter that we will adjust. I can give rest of details if you are available for gig Requirements: - I am open to suggestions and am flexible with the approach to automate this task. - The ideal candidate should have strong knowledge and experience in VBA automation. Timeline: - ...