MS EXCEL - VBA & Macro Development (Moderate)
Budget: €8 – €30 EUR
As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks.
I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file.
This tool will allow us to transform a specific Input file into another Output file.
• Input: catalog_product_option-YYYY-MM-DD hh_mm_ss.xlsx
• Output: ImportAPO-v1.0.xlsx
The 2 files are attached, with a color mapping to recognize the columns in scope.
In summary, we need to be capable to issue an export file in a specific format (see attached picture “Mockup.png”):
• Specific Orders of the column (Green)
• Suppress the duplicated values for some line items, on 3 fields.
The macro allows to:
• Generate the Output in a separate spreadsheet (which captures only the required fields and re-arrange them)
• Optional: Enable the Save function (allowing to define the saving location).
o Default the Saved name as: ImportAPO-v1.0.xlsx (Allowing me to select the saving location).
Important:
The Macro must not be attached to a workbook, but needs to be attached to the set of Excel Macro.
Reason:
The Input file can be extracted on-demand.
Skills and experience required:
- Expert in MS Access VBA and Macro.
- Advanced knowledge on the coding functions.
- Ability to challenge or question the BRD in a constructive manner
- Potentially propose functional amendment/solutions which serve the ultimate goal.
- Ability to work with provided designs or suggest design recommendations
- Strong communication skills to discuss additional features.
- Ability to align with project lead and other developers under the project.
- Access to Trello Dashboard and MS TEAMS for collaboration purposes.
The following constraints needs to be considered:
- Need ability to clearly understand the technical requirements as per this description
- End-project documentation.
This project will lead to other mission if it is achieved with success, within time, and gives satisfaction.
Thanks to Bid for the project only if the mission charter falls under your technical and non-technical perimeter.
Perfect Written/Oral communication in English, French or Russian is a must.
Reliability: Given the importance of these automations for my new business, I need someone who can deliver on time and with quality.
Please share your relevant experience, and if possible, any examples of your past work in Excel VBA automation. Thank you!
I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file.
This tool will allow us to transform a specific Input file into another Output file.
• Input: catalog_product_option-YYYY-MM-DD hh_mm_ss.xlsx
• Output: ImportAPO-v1.0.xlsx
The 2 files are attached, with a color mapping to recognize the columns in scope.
In summary, we need to be capable to issue an export file in a specific format (see attached picture “Mockup.png”):
• Specific Orders of the column (Green)
• Suppress the duplicated values for some line items, on 3 fields.
The macro allows to:
• Generate the Output in a separate spreadsheet (which captures only the required fields and re-arrange them)
• Optional: Enable the Save function (allowing to define the saving location).
o Default the Saved name as: ImportAPO-v1.0.xlsx (Allowing me to select the saving location).
Important:
The Macro must not be attached to a workbook, but needs to be attached to the set of Excel Macro.
Reason:
The Input file can be extracted on-demand.
Skills and experience required:
- Expert in MS Access VBA and Macro.
- Advanced knowledge on the coding functions.
- Ability to challenge or question the BRD in a constructive manner
- Potentially propose functional amendment/solutions which serve the ultimate goal.
- Ability to work with provided designs or suggest design recommendations
- Strong communication skills to discuss additional features.
- Ability to align with project lead and other developers under the project.
- Access to Trello Dashboard and MS TEAMS for collaboration purposes.
The following constraints needs to be considered:
- Need ability to clearly understand the technical requirements as per this description
- End-project documentation.
This project will lead to other mission if it is achieved with success, within time, and gives satisfaction.
Thanks to Bid for the project only if the mission charter falls under your technical and non-technical perimeter.
Perfect Written/Oral communication in English, French or Russian is a must.
Reliability: Given the importance of these automations for my new business, I need someone who can deliver on time and with quality.
Please share your relevant experience, and if possible, any examples of your past work in Excel VBA automation. Thank you!