Back to listings
MARTINS M.Remote

Excel Automation Specification for Risk and KPI Review Logs

Project-Based

Description

I have an Excel workbook containing two worksheets:

  1. Risk & Opportunity Register This sheet includes the following columns:
  2. Risk Review Log This sheet contains the same columns: I want the following automation: Whenever any of the listed columns are updated in the Risk & Opportunity Register, the updated row should automatically be added to the Risk Review Log, without overwriting any existing data in the log. The new entry should simply append to the next available row.

And the same process should be applied to the second workbook titled Quality Objectives KPIs Trackers and Review Log. The columns in this workbook are: Please note that the Notes column from the source sheet is mapped to the Comments column in this workbook

whenever specific columns are updated in the Risk & Opportunity Register, the full updated row should automatically be appended to the Risk Review Log, without overwriting any existing entries. Each change simply adds a new record to the next available row, preserving a full audit trail.

Only updates to the specified columns trigger the log entry Existing data in the log remains untouched Each update is captured as a new row for traceability The process should be able to run automatically with no manual copying

Budget: GBP 10 (Fixed Price)

Proposals: 12 freelancers have applied