Can VBA copy one line of a table to another specific table (based on a cell value in the row)?

Contributor

I have multiple tables in a workbook, and I am trying to find some code that will allow me to auto-add a line in the main table ("Work Orders") to one of each engineer's personal tracking table. I wanted the triggering event to be when the line on Work Orders table was updated with the assigned engineer's name, which would then add it to the last line on their own table. Is this possible? 

 

In the attached example workbook, when the value of cell O3 is changed to "Sara", I need the entire row to be copied and moved to the last line on Sara's ledger (worksheet "Sara"). In my actual workbook, I have separate worksheets for each engineer, so this would need to be able to account for multiple conditions. 

0 Replies