Amend existing Excel Macro

We have an existing macro that we run on the attached samples data that was written by a developer that is not longer working with us. We now require an additional 4 criteria adding onto the macro that takes data from a worksheet in the sample data called ‘Checklist Data Report 1’ the column titles are as follows; 1 Lilly reason of ARF loop 2 Lilly number of TC loop 3 Lilly reason of TC loop 4 Lilly number of ARF loop Data should come from PIDF (Primary Key) and then lookup from Column G in source data at corresponding IDs; 1 15 2 17 3 18 4 14 The value on the resulting spreadsheet report should be taken from the field value from column I of the source data. Please see attached some sample data and a copy of the existing macro that must be extended to include the 4 new columns as described. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform Windows