If Column N in Table2 is “Yes”, then macro should run to copy column A to G in table2 and paste at the end of Table3 in column B to H.
The Marco should copy on the row for which Column N is Yes.
Basically, its a list of existing orders and once the order is completed the user types Yes in column N (table2). Then I need that specific order to transfer to Table3(completed orders table).
Let me know if its unclear and I'll try to explain again.