Writting Excel Macros

Writting 4 macros that include: 1) Opening .txt file, which has the pipe symbol (|) as a separator, in Excel as a delimited file. 2) Deleting columns 3) Replace one string of text with another 4) Inserting a row and filling in the cells for column headers 2nd Macro would include 1) sorting records by columns 2) Make a copy of the records that have the same value within that column 3) Create a new worksheet, naming it with the value from the selected column, and inserting the same column headers as mentioned above in point 4 4) Paste the copied records into the new worksheet An example of the above, If the sort from the first step resulted in 15 records with the value AA in the column and 32 records with the value BB and 76 records with the value CC, then when the macro was finished running I would have three new worksheets (one named AA, one named BB, and one named CC) each with the same column headings as produced from the first macro described above. Worksheet AA will have the 15 records, BB will have the 32 records, and CC will have the 76 records. Third Macro: 1) Filter the records with a word or phrase 2) Then copy and paste the results into a new worksheet using the word or phrase as the name of the worksheet. 3) Then allow me to either sort again with a different word or phrase or exit the macro. Fourth Macro: The same as the third macro with this addition: Between point 2 and 3 above: Then delete the filtered records so that none of those records are available for the next word or phrase used to filter. This will result in a shorter list to filter with each consecutive time. Please fell free to ask for any clarification or the points above if needed. Also, if you have suggestions I am glad to hear them. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform The returned files will be in a .csv format