Excel VBA Guru for Custom Macros
Budget: $10 – $30 AUD
I need a Microsoft Excel wizard who is skilled in Visual Basic for Applications (VBA). Your primary tasks will include:
- Leveraging VBA within microsoft excel to perform find and replace tasks on external files (.html files)
- An excel spreadsheet placed in a folder will be able to...
Macro 1
Will list all the files in the current directly in column A
Macro 2
Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found)
Macro 3
Will open and find the string listed in column A and replace it with the new string listed in Column D
Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating macros, utilizing VBA for intricate data manipulation tasks, and swiftly understanding user requirements. I'm looking forward to kick-start this project ASAP.
- Leveraging VBA within microsoft excel to perform find and replace tasks on external files (.html files)
- An excel spreadsheet placed in a folder will be able to...
Macro 1
Will list all the files in the current directly in column A
Macro 2
Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found)
Macro 3
Will open and find the string listed in column A and replace it with the new string listed in Column D
Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating macros, utilizing VBA for intricate data manipulation tasks, and swiftly understanding user requirements. I'm looking forward to kick-start this project ASAP.