Write a macro for Excel to automate the creation of two ouptut files from one input file

For this project, please write an Excel macro using VBA. The macro will create two output .csv files using one input .csv file. Actions in the macro include deleting rows and columns based on values contained within, rearranging the order of columns, inserting new columns, editing values, and saving the output files with a certain filename format based on the date. Attached are the specific instructions in "product [login to view URL]". Also, a sample [login to view URL] and the two output files that would be created from that input file using the macro. Please let me know if you have any questions before submitting a proposal. Thank you!