Create four MS Excel macros to process/clean spreadsheet data

The goal of this project is to write four Excel macros to process data in Excel. The macros will perform a variety of functions to manipulate the data in an Excel workbook including: -Deleting rows based on pre-defined (hard-coded) criteria in a particular cell, including if a cell is blank (but the row is otherwise populated) -Deleting columns -Adding columns and populating the column with values based on a formula or defined criteria -Creating new worksheets and moving specified columns to those worksheets -Deleting rows based on the presence of duplicate values in the same column -Display a message based on the value of a cell or variable -Accept input from a user Raw (unprocessed) data and an example of the successful output will be provided to assist with this task. I will be available to answer questions if they arise during the development process. Macros must be able to handle sheets with significant amounts of data, including those with up to 500,000 rows. Macros must be able to operate on the Mac OS version of Microsoft Excel (I believe macros are cross-platform compatible but want to include this to be sure - work will be validated on MS Excel 2016 for Mac). Please review the attached requirements for the macros before placing a bid so the level of difficulty of this project is clear. Three different Excel workbooks will be provided as part of this project. Two of the workbooks will each require one macro and the third will require two macros. Interested bidders should be have experience with coding Excel macros in Visual Basic for Applications.