I have an EXCEL spread sheet that contains a macro button that creates a new spreadsheet from a .TXT file that is always formatted in the same way, with similar looking data. This new spreadsheet also then generates a specific chart from three of the columns. I need to add to that automation with either another macro button, or preferably by extending the first button to change that original chart to use two different columns (the formula for the chart has recently been changed), and to perform some additional automation steps such as adding a couple more calculated values, and formatting some of the rows or columns with color highliting, etc.
A detailed specification document is attached along with the spreadsheet containing the macro Button that gets run against the enclosed sample .TXT file that must be manipulated. In addition, a sample RESULT spreadsheet is enclosed to clarify the specifications for this Phase II automation - it is called "[login to view URL]"
This first phase of automation is less complex than the first, and the first was accomplished by a freelancer from this service for $40. That freelancer however has not been available recently, and I must complete the project.
The ending result must be able to work on both a MAC and a PC - as we will need it to run equally well on both.