Excel VBA Automation Expert Needed
Budget: $250 – $750 USD
I'm seeking a skilled VBA programmer to help automate routine tasks in my Excel spreadsheets. The primary objective is to link various raw data from multiple Excel files in order to generate desired outcomes.
Key Responsibilities:
- Develop a VBA script to automate the linking of raw data across multiple Excel files.
Ideal Skills:
- Proficient in VBA and Excel
- Experience in automating tasks using VBA
- Strong understanding of data manipulation and analysis
- Ability to create efficient, reliable scripts
The details of the jobs as follow:
We have an Excel file that I want to link and capture data.
Basically, we have this file call Master Production Schedule (MPS) whereby it shows all the Finished Goods (FG) that production department want to run on which date and at what qty and at which production line or at which machine. The qty can be in cartons or batches.
I have another file which shows the open Purchase Order (PO) whereby it shows all the balance qty of a PO and the planned delivery date for certain qty. We call this file as Order Tracking (OT).
We also have another file BOM which shows what are the material needed and what is the qty needed to produce one batch or one carton of certain FG.
We have another file named Store which shows the stock figure as of today's date.
We want to have an Excel file (file A) whereby when we copy and paste the MPS to this file A, it will prompt with qty that we need to purchase, and it will define the delivery date and qty for a specific delivery date. It should take into consideration of the today's stock figure from Store file and any open PO qty before informing us the required qty for specific material's Item Code on a specific date. Basically, the required qty should take into consideration of standard packaging (round up to the nearest standard pack). FYI, all item code will be listed in this file A as well
I would like to schedule a Teams or Zoom meeting to explain more before you start the job.
Please advise what is the cost for this project. Please send me quotation at chengee dot lim at qsrbrands dot com dot my
Key Responsibilities:
- Develop a VBA script to automate the linking of raw data across multiple Excel files.
Ideal Skills:
- Proficient in VBA and Excel
- Experience in automating tasks using VBA
- Strong understanding of data manipulation and analysis
- Ability to create efficient, reliable scripts
The details of the jobs as follow:
We have an Excel file that I want to link and capture data.
Basically, we have this file call Master Production Schedule (MPS) whereby it shows all the Finished Goods (FG) that production department want to run on which date and at what qty and at which production line or at which machine. The qty can be in cartons or batches.
I have another file which shows the open Purchase Order (PO) whereby it shows all the balance qty of a PO and the planned delivery date for certain qty. We call this file as Order Tracking (OT).
We also have another file BOM which shows what are the material needed and what is the qty needed to produce one batch or one carton of certain FG.
We have another file named Store which shows the stock figure as of today's date.
We want to have an Excel file (file A) whereby when we copy and paste the MPS to this file A, it will prompt with qty that we need to purchase, and it will define the delivery date and qty for a specific delivery date. It should take into consideration of the today's stock figure from Store file and any open PO qty before informing us the required qty for specific material's Item Code on a specific date. Basically, the required qty should take into consideration of standard packaging (round up to the nearest standard pack). FYI, all item code will be listed in this file A as well
I would like to schedule a Teams or Zoom meeting to explain more before you start the job.
Please advise what is the cost for this project. Please send me quotation at chengee dot lim at qsrbrands dot com dot my