Copy to a different sheet when all complete
What automation is best in this scenrio:
I have a lesson learned log on individual projects. I want entries to copy to a central version for review by management.
The copy/move to a different sheet seems to be limited to a change to a single cell whereas I want it to copy when all cells (the complete row) are complete.
Is there a way to automate and send a completed row?