Ciao Momkaa Y.,
I am Luigi, an Excel expert with over 5 years of experience. I have carefully read your project requirements and I am confident that I can assist you with your urgent Google Sheet code assistance.
Based on your description, you have provided a code that compares two different columns and appends the first column with anything different. However, you mentioned that you need to add a criteria based on the "Not Active" condition, and you also want the code to run on edit when the source sheet is updated.
To achieve this, I will modify the existing code to include the criteria "Not Active" and implement the on edit trigger. Here is how I will approach the project:
1. Get the active spreadsheet and define the source and target sheets.
2. Retrieve the values from the source sheet column A, considering the "Not Active" condition.
3. Retrieve the values from the target sheet column A.
4. Compare the two sets of values and identify the differences.
5. Clear the content of the target range.
6. Concatenate the differences with the target values.
7. Set the updated values to the target range.
I believe that discussing the project in more detail would be beneficial to ensure the best quality deliverable. I would appreciate it if we could start a chat to discuss your specific requirements and any additional details you may have.
Thank you for considering my proposal. I look forward to discussing the project further with you.
Thanks,
Luigi