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
Podcast Listener Growth Strategy Category: Analytics, Content Strategy, Digital Marketing, Internet Marketing, Podcast Marketing, SEO, Social Media Marketing, Social Networking Budget: $2 - $8 USD
Two AI-Generated Marketing Videos Category: After Effects, AI Animation, AI Content Creation, AI Video, Animation, Graphic Design, Video Editing, Video Services Budget: $30 - $250 USD
01-Jun-2026 09:53 GMT
Cartoonish Educational Story Character Category: 2D Animation, 2D Drawing, Caricature & Cartoons, Character Illustration, Creative Design, Graphic Design, Illustration, Video Services Budget: ₹12500 - ₹37500 INR
01-Jun-2026 09:52 GMT
Comprehensive Commodities Trading App Category: App Development, Financial Analysis, Graphic Design, IPhone, Market Analysis, Market Research, Mobile App Development, Trading, UI / User Interface, User Interface / IA Budget: ₹1500 - ₹12500 INR
01-Jun-2026 09:51 GMT
Battery-Powered LoRa PCB Design Category: Arduino, Circuit Design, Electrical Engineering, Electronics, ISM Radio Module, LoRa, Microcontroller, PCB Design And Layout, PCB Layout, Radio Frequency Engineering Budget: $250 - $750 USD
01-Jun-2026 09:51 GMT
Fixed-Wing Motor Mount Design Category: 3D CAD, 3D Design, 3D Printing, Aerospace Engineering, Mechanical Engineering Budget: ₹1500 - ₹12500 INR
01-Jun-2026 09:50 GMT
Real Estate Tour Video Editor Category: Adobe Premiere Pro, After Effects, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: ₹600 - ₹1500 INR