Deliverable: A Macro that derives and organizes data from information in the TERM CODE INSTRUCTION sheet, DATA SHEET and portions of the DECISION CONTROL sheet. This macro will create TERM sheets, add data to the DECISION CONTROL sheet and create a SUMMARY DATA sheet as described in the instructions attached. The TERM CODE INSTRUCTIONS, DATA SHEET and some data in the DECISION CONTROL sheet will change on each run and need to be provided by the user.
The Macro needs to be user friendly and come with clear instructions so that anyone with an understanding of the data sets involved can run it without confusion.