I have an Excel workbook containing two worksheets: 1. Risk & Opportunity Register This sheet includes the following columns: • Review Notes • Next Review Date • Review Outcome • Reviewed By • Review Date • Risk ID 2. Risk Review Log This sheet contains the same columns: • Review Notes • Next Review Date • Review Outcome • Reviewed By • Review Date • Risk ID 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: • KPI Name • Review Date • Comments • Review Name 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
• Avoid duplicate logs • Log timestamps • Track old vs new values • Restrict logging to completed rows only
ANDROID VIRTUAL CAMERA SYSTEM Category: Android App Development, Android SDK, Mobile App Development, WebRTC Budget: $750 - $1500 USD
25-Mar-2026 11:04 GMT
Zoho CRM Automation and Systems Specialist Category: AI (Artificial Intelligence) HW / SW, API Integration, Automation, CRM, HTML, PHP, Web Design, Zapier, Zoho, Zoho Creator, Zoho CRM Budget: $15 - $25 AUD
25-Mar-2026 11:04 GMT
Modern Office Development LDP Design Category: Architectural Engineering, AutoCAD, Building Architecture, Building Design, Building Information Modeling, CAD / CAM, Construction, Graphic Design Budget: $250 - $750 USD
25-Mar-2026 11:03 GMT
Artikel Blog Pengembangan Web Category: Article Writing, Content Writing, CSS, HTML, JavaScript, PHP, Web Development, WordPress Design Budget: $115 - $200 HKD
Leads Generation for Field Services v2 Category: Data Collection, Data Entry, Email Marketing, Excel, Lead Generation, Leads, Sales, Web Search Budget: $10 - $30 USD
25-Mar-2026 11:01 GMT
Dental Social Directory Platform Category: Laravel, PHP, UI / User Interface, User Experience Research, User Interface / IA, UX / User Experience, Web Design, Web Development, WordPress Budget: $30 - $250 USD
Shopify Store Tracking Overhaul Category: Digital Marketing, Google Ads, Google Analytics, HTML, JavaScript, Meta Pixel, PHP, Shopify Budget: $30 - $250 USD
SEO Specialist to Boost Website Authority Category: Content Strategy, Internet Marketing, Keyword Research, Link Building, Marketing, SEMrush, SEO, SEO Auditing Budget: $30 - $250 AUD
25-Mar-2026 10:58 GMT
Real Estate Marketing Specialist Category: Content Creation, Email Marketing, Facebook Ads, Facebook Marketing, Instagram Marketing, Internet Marketing, Marketing, Social Media Marketing Budget: $250 - $750 USD
