Create Excel VBA Macros
Budget: $8 – $15 USD
ou are required to create Excel VBA Macros that have forward compatibility starting from Excel 2016.
------------------------------------------------------------------------------------------------------------------------------------
-you must have knowledge on advanced algorithms to know how to deal with Very Big number of rows of data efficiently (search and sort algorithms)
-you must be able to import csv, tsv, xlsx files from local device to the main excel workbook
-you must be able to export excel files into csv, tsv, xlsx files and move them on local device
-you must be able to manipulate excel data in an efficient way using a mix of both macros and functions
-You are required to write clean code and provide comments to illustrate what does your code do, a video illustrating what you are doing is a plus.
------------------------------------------------------------------------------------------------------------------------------------
*details on each job will be shared on private chat, you are required to leave a bid if you can work on long term projects on a fixed/hourly basis, requirements won't be hard so you are expected to do deliveries on the next day or the day after.
*this can go as long as you can keep up with the pace of the requirements and do not make late deliveries while maintaining the quality of your code.
------------------------------------------------------------------------------------------------------------------------------------
-you must have knowledge on advanced algorithms to know how to deal with Very Big number of rows of data efficiently (search and sort algorithms)
-you must be able to import csv, tsv, xlsx files from local device to the main excel workbook
-you must be able to export excel files into csv, tsv, xlsx files and move them on local device
-you must be able to manipulate excel data in an efficient way using a mix of both macros and functions
-You are required to write clean code and provide comments to illustrate what does your code do, a video illustrating what you are doing is a plus.
------------------------------------------------------------------------------------------------------------------------------------
*details on each job will be shared on private chat, you are required to leave a bid if you can work on long term projects on a fixed/hourly basis, requirements won't be hard so you are expected to do deliveries on the next day or the day after.
*this can go as long as you can keep up with the pace of the requirements and do not make late deliveries while maintaining the quality of your code.